Mapping of LINQ to SQL Object and Relational Object(Sql Server Object)

Mapping of LINQ to SQL Object and Relational Object(Sql Server Object)
 
The following table shows the relationship between the LINQ to SQL object model and the corresponding relational model.
The LINQ to SQL object model provides the fundamental elements for working with and managing
relational objects. It is via this model that a relational model is mapped to and expressed in the
developer’s programming language.
In the LINQ to SQL object model, database commands are not issued against the database directly. As a
developer, you simply change values and execute methods within the confines of the object model. LINQ
to SQL then translates those changes or methods into the appropriate SQL commands and funnels them
through to the database to be executed.
Typical and more described details are showing below in table to map both objects.

Relational Object	LINQ to SQL Object
Database	Data Context
Table	Entity class
Column	Class member
Foreign-key relationship	Association

Hope this little excerpt help to .Net freaks.
To know more about MVC kindly go through with the links given below:
· Smart Working With Custom Value Providers in ASP.Net MVC
· Invoke Action With Model Binders in MVC
· Extension Helpers Method in MVC
· Custom Button With TagBuilder Using MVC Razor Engine
· Precompiled Razor View Using RazorGenerator MVC and PreCompiledViewEngine in MVC 4
· RETURN MULTIPLE MODELS IN SINGLE VIEW IN MVC3
· CALL CONTROLLER ACTION METHOD FROM JQUERY USING AJAX
· EXECUTION ORDER OF FILTERS IN MVC 4 WITH PRACTICES: IMPORTANT FAQ
· MEANING OF SCAFFOLDING IN MVC
· REMOVE AMBIGUTY OF CONTROLLER NAMES IN MVC APPLICATION
· CUSTOM BUTTON WITH TAGBUILDER TECHNIQUE USING MVC RAZOR ENGINE
· CONVERSION HELPERS IN MVC RAZOR: VALIDATING POSTED DATA
Thanks
Stay Happy and Stay Coding

Categories: Entity Framework & LINQ