Working With SQL Server HierarchyId Data Type In .NET Application

Recently I was working with some hierarchical data stored in SQL Server. The data was related to products where each product is a package which includes other packages which in … Continue Reading →

Use LINQPad To Query Entity Framework

LINQPad is a must have tool for all .NET developers who write LINQ queries. It allows you to write and execute LINQ queries without compiling your code. In this post … Continue Reading →

A Little Milestone in ThereforeSystems Journey

This post is to mark a little milestone for ThereforeSystems. My second post on this site was a LINQ To SQL Tutorial which was a basic tutorial to get the … Continue Reading →

ADO.NET Data Services Logical Operators

In this post we will look at Logical Operators in ADO.NET Data Services. These operators can be used as filter expressions in our requests and ADO.NET Data Services applies the … Continue Reading →

Execute Stored Procedure With ADO.NET Data Services

Introduction In an earlier article I looked at how DO.NET Data Services can be used with ASP.NET. In this post I will talk about using ADO.NET Data Services to retrieve … Continue Reading →

ADO.NET Data Services With ASP.NET

Introduction In this tutorial we will look at how ADO.NET Data Services can be used to create services which are consumed by ASP.NET client. We will use Adventure works Lite … Continue Reading →

Insert Master Detail Data With LINQ To SQL

Best thing about running One .Net Way is interaction with members of developer community. I thoroughly enjoy answering questions which come my way through this site. Early in the morning … Continue Reading →

Select Max Value With LINQ To SQL

Today I was asked a question by a developer on my team. The question is “How do you select MAX value for a column in a table with LINQ To … Continue Reading →

Create T-SQL CASE Statements With LINQ To SQL

I was recently helping Nosh with a LINQ To SQL query where he wanted the resulting T-SQL query to have CASE statements. Having CASE statements in T-SQL queries is a … Continue Reading →

Get Last Row From Table Using LINQ To SQL

This query returns the last row from Sales.Customer table in Adventure Works database. I am using LINQPad to write and execute my query.

Here is the result as displayed … Continue Reading →

Page 1 of 3123