The fundamentals operations that a storage system provides are the CRUD ones. CRUD stands for CREATE, READ, UPDATE, DELETE and corresponds to the SQL statements INSERT, SELECT, UPDATE and DELETE respectively. This post will show you how to query CRUD operations with LINQ to SQL and how to call a stored procedure defined in your SQL Server, as well. In a previous post we have seen how to create your entity model for your LINQ to SQL engine, in other words how to map your entity classes to your database tables. It is really important to know how to create and map your own entities but in most cases you might want to rely on particular tools which help you accomplish this task. Be aware that writing mapping information by hand can be time consuming and error-prone. In this post, we will use the SqlMetal.exe tool to generate the Northwind database entities. Then, we 'll use these entities in our project to query CRUD operations. Let's start.


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

</ span>C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials, LINQ to SQL, Store Procedures, LINQ, LINQ to SQL Storeprocedures