Deferred Execution and Immediate Execution in LINQ

Deferred Execution executes the query only when Loop starts. What I mean here is that, we iterate through the query variable to get the result.       Here the result variable does not contain the actual result. To get the result, we may iterate through the result (query) variable in loop as many time as … Continue reading Deferred Execution and Immediate Execution in LINQ

Var versus IEnumerable in LINQ

We have seen normally Or Now question is where to use var or IEnumerable? Let us first have a look on both key words Var derives type from the right hand side. And its scope is in the method. And it is strongly typed. IEnumerable is interface which allows forward movement in the collection. Now … Continue reading Var versus IEnumerable in LINQ

Listing columns name with type of a table using LINQ

After my last post, I got a question asking how to list all the Column names of a given table using LINQ. Before going through this post, I recommend you to read Get All the Tables Name using LINQ Let us say, you have a table called dbo.Person and you need to find all the … Continue reading Listing columns name with type of a table using LINQ

Get All the Tables Name using LINQ

We need to list all the table name of the DataContext. This is very simple through LINQ mapping. 1. Add the namespace 2. Get the model from type of datacontext DataClasses1DataContext is your datacontext class created by LINQ to SQL. 3. Use GetTables() method to list all the tables name using System; using System.Collections.Generic; using … Continue reading Get All the Tables Name using LINQ

WCF Service library: Creating, Hosting and consuming WCF service with WCF Service Library project template

In this article we will walkthrough on creating a WCF Service by choosing WCF Service Library project template. Step 1 Create a WCF Service Library project. Delete all the default codes created by WCF. Step 2 Modify Operation Contract as below, Implement the service as below Step 3 Leave App.config file as it is with … Continue reading WCF Service library: Creating, Hosting and consuming WCF service with WCF Service Library project template

WCF Data Service with LINQ to SQL Class

We have seen many articles and blogs talking about using WCF Data Service with ADO.Net Entity model generated class as model. In this article we are going to see, how to use WCF Data Service with LINQ to SQL Class. There are three conditions while using LINQ to SQL class with WCF Data Service. One … Continue reading WCF Data Service with LINQ to SQL Class

Presented at Pune Dev. Con on 19th December 2010

Download PPT of session from here I would start with saying a great two day event at Pune. I was attending first time any event in Pune and I were overwhelmed. I really want to thanks Mahesh to pulling such a great event. Pune user group core members really deserve applause for their hard work … Continue reading Presented at Pune Dev. Con on 19th December 2010

Speaking at DevCon , Pune – December 18-19, 2010 on WCF Data Service

Register Here About Dev Con Source: http://www.puneusergroup.org/ Event Date: 18 December and 19th December 2010 Event Venue: My Speaking Detail Date: 19th December 2010 Time: 10 am to 11 am Topic: ODATA and WCF Data Service Summary: ODATA is HTTP or web protocol to querying or manipulating data. ODATA uses HTTP, JOSN or ATOM.ODATA can … Continue reading Speaking at DevCon , Pune – December 18-19, 2010 on WCF Data Service