English German Spanish French Chinese

Sign In
Join

Home › Learn › LINQ Videos › How Do I: LINQ to SQL: Querying the Database

[How Do I:] LINQ to SQL: Querying the Database

This video shows how to query a database with LINQ, the underlying SQL with a query visualizer, databinding to ASP.NET controls and record paging.

Presented by Scott Stanfield

Duration: 6 minutes, 19 seconds

Date: 15 November 2007

Watch VB Video C# Video | Download VB Video C# Video | VB Code C# Code

Audio downloads: AAC AAC | WMA | MPEG-4 MPEG-4 | MPEG-3 MPEG-3 | MPEG-2 MPEG-2

Comments : 21

Leave a Comment

pmclinn : On April 13, 2008 7:07 PM said:

The linq video's have the right idea but are presented wrong. The Video production is great and the author's voice is very clear and understandable. However, the demo falls short because of several problems.

The largest problem is the instructor assumes that the audience knows the northwind db. If the instructor went between the db and the code more often it would make the examples easier to understand. [e.g. here is an example of how we would setup a right-join or this may be a more efficient way to cascade a delete update or what does the "aggregate" command do?

The other comment I would like to point out, is we have yet another native C# coder writing VB code. This is poor form. VB and C# coders take too separate coding paths. I do not get why Microsoft wants to abandon their biggest programming group. The "==" mistake made me throw up in my mouth as a VB native. When I watch a c# example I want to see a C# pro and likewise for the VB videos.

These video's are so important to the .net language users that I believe more time should be given to the developer's that create them. The better these video's are the better the products will be that take advantage of the language.

Thanks for these lessons though, as they are much appreciated.

satalaj : On May 10, 2008 8:45 AM said:

I would like to see C#.net version instead clicking and downloading C# video link.

vik20000in : On July 09, 2008 2:27 AM said:

good video

cv_vikram : On August 14, 2008 6:26 PM said:

thanks....

S.Pirashanth : On August 28, 2008 2:38 AM said:

Many thanks for the great videos

vpmragu : On September 22, 2008 1:26 AM said:

hi Scott,

many thanks for this video.

santosh.singh : On September 24, 2008 1:53 AM said:

excellent video . 5 start for you

vinz : On September 26, 2008 12:25 PM said:

EXCELLENT!

djibril_chimere_DIAW : On October 24, 2008 5:56 AM said:

Thanks !Jërëjëf!

jugatetodo : On November 19, 2008 2:41 PM said:

Me parecio excelente lo que si seria bueno un video de linq para conectar con mysql con procedimientos

beaudeep : On December 14, 2008 9:44 AM said:

Thanks For the Video

MaicoTamayo : On December 23, 2008 1:15 AM said:

Good video, hope to make a mysql or ingres version of this video... Soon

trulyperfect : On January 04, 2009 9:31 PM said:

Thanks for the great video! Very informative.

rami_nassar : On January 12, 2009 10:05 AM said:

good job.. good technology..

softwarebest : On January 21, 2009 6:57 AM said:

Very Excellent Video. Nice

vvphan : On February 24, 2009 11:52 AM said:

thanks ... very much.

vvphan : On February 24, 2009 12:01 PM said:

if you have orther video, please upload to 4rum

bfaulk1 : On April 15, 2009 10:11 PM said:

At 2:02 of th evideo it shows the data query with an 'hourglass' when hovering over product. I don't get that here. I've checked on both my systems. Vista Business x64, VS 2008 SP1

Any ideas?

Thanks

bill

bfaulk1 : On April 15, 2009 10:43 PM said:

Please ignore my post today at 2:11 PM. I found the answer. I just needed to build and deploy the LinqToSqlQueryVisualizer sample dll. Once I followed the instructions it works like a charm.

Sorry for the false alarm.

thanks

-bill