Using LINQ to SQL (Part 1)

home
database
view story

18 Kicks

Using LINQ to SQL (Part 1)(weblogs.asp.net)

submitted by MrOK(90) 5 years ago

"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: 57
Tweet

tags: SQL LINQ Orcas using To another

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:

dimitris(0) -

ramiljoaquin(465) -

G_Sharma(0) -

tendrel(5)

More who kicked this story...

Comments:

posted by ajdotnet(2940) 4 years, 8 months ago 0

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 ronin(0) 3 years, 9 months ago 0

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 Jemm(9604) 3 years, 9 months ago 0

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)

Most Active Users

What's this?