Using LINQ to SQL (Part 1)

Why not join our community?, there are 8 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

16
kicks

kick it

Using LINQ to SQL (Part 1)

submitted by MrOK 1 year, 3 months ago

weblogs.asp.net — "LINQ to SQL is an O/RM (object relational mapping) implementation that ships in the .NET Framework "Orcas" release, and which allows you to model a relational database using .NET classes. You can then query the database using LINQ, as well as update/insert/delete data from it. LINQ to SQL fully supports transactions, views, and stored procedures. It also provides an easy way to integrate data validation and business logic rules into your data model."

3 comments | category:

Database | Views: 8 | Get KickIt image code

tags: SQL, LINQ, To, using, ORM | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

MrOK -

JudahGabriel - ASPrunner - ajdotnet -

gavinjoyce - naimul - Widescreen - KirillOsenkov -

armencz - isaacab - asolvent - cheetahtech - mcmanus.paul - vinc -

tendrel - G_Sharma

Comments:

This post starts a series about LINQ that is IMO the most comprehensive coverage of the topic. The more you read the more you grasp the power of LINQ (and the VS support).
IMO Linq will be the prevalent means of data access tomorrow, replacing ADO.NET datasets (which really _is_ a change in strategy) and homegrown ORMs.

posted by ajdotnet 11 months, 21 days ago

OK I am new for LINQ I am not familiar with technology, and I want to ask Why I should start use LINQ, why LINQ is better than ohter ways to connect to database.Easier sintacsys is not good enough for me , is there something that LINQ gives you that no other method to connect to database doesn't.we made a reaserch in my company is it worthy to convert all project to LINQ this labour-consumption task , o help me to make a right decission.

posted by ronin 1 month, 6 days ago

LINQ isn't only about connecting to a database or just one ORM among others. Just learning to use LINQ to Objects effectively is very powerful. I think that learning LINQ is important if one wants to be efficient with C# or VB.NET. I'm sure that the importance of the LINQ will grow in coming versions of .NET.

Btw, one example how powerful LINQ is: Raytracer built with a single LINQ-query: http://blogs.msdn.com/lukeh/archive/2007/10/01/taking-linq-to-objects-to-extremes-a-fully-linqified-raytracer.aspx (Not very efficient, but shows the expressiveness)

posted by

Jemm 1 month, 6 days ago