After some creative googling I found out that the problem was with the file called dsref80
This file is located in the following folder on an x64 machine: “C: Program Files (x86)Common Files Microsoft Shared Visual Database Tools”.
Please use the database structure given below, if you want to try the following examples directly.
I am assuming, you already know how to create dbml/linq to sql classes: Being Lin Q as a ORM, it’s quite easy and sql syntax free way to insert data using Lin Q.
I will be writing on some more advance level linq to sql usage soon. Recently, I have discussed about getting started linq to sql in c#That articles also covered for creating select query for retrieving both single and multiple results.This is partly due to the Query Execution Plans which get created on SQL Server, been able to control when these Execution Plans get re-created, and also optimising the query based on database statistics, which isn't something LINQ to SQL deals with.
Also as Microsoft have said they're not going to be providing any more updates for LINQ to SQL, they're concentrating on the Entity Framework, it seems like a technology which will fade away.This will be helpful for debugging purpose and also to learn/know more about original sql syntax.