How Do I: LINQ to SQL: Executing Arbitrary SQLhttp://asp.netMon, 28 Dec 2009 11:38:43 GMTumbracoComments for How Do I: LINQ to SQL: Executing Arbitrary SQLenComment Posted by agarwaenhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlMon, 17 Mar 2008 20:05:16 GMT00000000-0000-0000-000000006862I know everyone is excited, so I be a bit more critic to this video podcast.

1. IMHO it is too short and too fast to the point. Not touching  it more deeply, i.e. why we are extending DataContext class instead of building our own factory, or it gets to the ExecuteCommand method just in the end of the video and then it immediately finish.

2. Would be better if Scott first of all told something about advantages/disadvantages of using SQL instead of LINQ (just a quick info and guide where to look for LINQ generated SQL statements), and touch in a bit more detail the ExecuteCommand method.

3. when will you support the "new" iPod Touch screen resolution in podcasts? It isn't much of a enjoyable experience watching them in present low-resolution state.

Thank you

]]>Comment Posted by mahir78http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlTue, 18 Mar 2008 05:36:53 GMT00000000-0000-0000-000000006863Its Great that Microsoft offers world's smallest tutorials for their new products! Hats off to you. :(

]]>Comment Posted by atarikghttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlThu, 20 Mar 2008 07:35:21 GMT00000000-0000-0000-000000006864Well kinda fast yet nice :)

]]>Comment Posted by Nezdethttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlTue, 25 Mar 2008 07:47:17 GMT00000000-0000-0000-000000006865Fulltext Search I need to use pass through SQL to LINQ

Are there some exemples how to do it??

]]>Comment Posted by Lee Dumondhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlTue, 08 Apr 2008 13:35:00 GMT00000000-0000-0000-000000006866Just would like to point out a couple of errors in the code:

In part9.aspx, line 31:

Product p = db.Products.Single(p => p.ProductName == "Foo");

You can't declare a local variable "p" in the lambda expression here, because "p" is already used to denote the Product. You could change it to something else, like:

Product p = db.Products.Single(prod => prod.ProductName == "Foo");

In Helpers.cs, line 57:

return ExecuteCommand("delete from products where ProductId={0}", instance.ProductID);

DeleteProduct is a void method, so it can't return anything.  You need to get rid of the "return" keyword.

]]>Comment Posted by DesmondFhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlMon, 26 May 2008 05:22:47 GMT00000000-0000-0000-000000006867What about SQLInfoMessageHandler

I really enjoyed this tutorial. It got me going within a couple of minutes. I need to display the SQL messages from RAISERROR.

]]>Comment Posted by xequencehttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlWed, 11 Jun 2008 14:36:00 GMT00000000-0000-0000-000000006868I would advise to whomever watches these tutorials that they are more understandable if you watch them in the correct order. Touching on specifics in every video is time consuming and Scott does a great job in not wasting time on old news.

]]>Comment Posted by cv_vikramhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlMon, 18 Aug 2008 10:55:36 GMT00000000-0000-0000-000000006869thanks....

]]>Comment Posted by TheDirtyBirdhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlThu, 21 Aug 2008 14:11:54 GMT00000000-0000-0000-000000006870Could you please post a link where I can download this video?

]]>Comment Posted by KShipshttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlSat, 20 Sep 2008 19:13:42 GMT00000000-0000-0000-000000006871Excellent videos. Learnt a lot from them.

Any chance of doing a video on how to apply security (ie behind a login) to this site? I'm a newbie so this might be quite obvious to implement but having issues with this project.

]]>Comment Posted by djibril_chimere_DIAWhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlFri, 24 Oct 2008 08:20:52 GMT00000000-0000-0000-000000006872Thanks! Jërëjëf!

]]>Comment Posted by brokensaberhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlTue, 11 Nov 2008 19:31:57 GMT00000000-0000-0000-000000006873I would like to see a video on using linq to import to a sql db using a data source like a csv file, xml, or xls.

]]>Comment Posted by Nowmanhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlTue, 16 Dec 2008 11:24:33 GMT00000000-0000-0000-000000006874The C# Code link goes to Part 8 of the series.

]]>Comment Posted by koolaidkidhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlTue, 24 Feb 2009 22:36:20 GMT00000000-0000-0000-000000006875holy cow, i've been looking for a way to do full text search (Contains, Freetext, Containstable..) through LINQtoSQL for the longest time, since fts isn't supportted by linq. so does this mean i can now use Contains in SQL? and it won't generate "%like%" statements instead?

]]>Comment Posted by vvphanhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlFri, 27 Feb 2009 02:05:57 GMT00000000-0000-0000-000000006876Help me:

I use linq to load data into the DropDownList, but when I code the server is how to get the ID (value) of the DropDownList? (I need to get value DropDownList.selectvalue)

]]>Comment Posted by abhinandanbansalhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlSun, 05 Apr 2009 15:16:08 GMT00000000-0000-0000-000000006877It is good. Thanks

]]>Comment Posted by ifucani2canhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-executing-arbitrary-sqlMon, 28 Dec 2009 11:38:43 GMT00000000-0000-0000-000000006878This is really a great Stuff!!

]]>