[How Do I:] LINQ to SQL: Updating the Databasehttp://asp.netTue, 24 Feb 2009 12:15:41 GMTumbracoComments for [How Do I:] LINQ to SQL: Updating the DatabaseenComment Posted by ShaunOhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseWed, 26 Mar 2008 22:11:44 GMT00000000-0000-0000-000000006711Nice video, bonus with your kid walking in asking to use your computer :D!

]]>Comment Posted by ramahhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 27 Mar 2008 04:53:37 GMT00000000-0000-0000-000000006712nice video. thank you

]]>Comment Posted by rtisserandhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 27 Mar 2008 10:56:48 GMT00000000-0000-0000-000000006713Would it be possible to get a VB version of this video?

]]>Comment Posted by dotNetNewbiehttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseMon, 21 Apr 2008 06:11:13 GMT00000000-0000-0000-000000006714Hi Scott,

Thank you for your great video. I'm following each one of them to start learning Linq.

In this video here, when you extend the class Order(public partial class Order) the intellisense doesn't work, and the namespace System.Data.Linq.ChangeAction is not recognized. It compiles right but qhen i run the project gives the following error message:

CS0234: The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

However, in the NorthWind.designer.cs the method recognizes the namespace...

partial void OnValidate(System.Data.Linq.ChangeAction action);

Can you tell me of something is missing?

Best regards,

Manuel

]]>Comment Posted by kteeplhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseFri, 06 Jun 2008 11:24:14 GMT00000000-0000-0000-000000006715VB PLEASE!!

]]>Comment Posted by McGuirehttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseFri, 06 Jun 2008 17:50:53 GMT00000000-0000-0000-000000006716I agree.  Will the next several be done in VB at some point?

]]>Comment Posted by vasireddybharathhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseMon, 23 Jun 2008 22:28:36 GMT00000000-0000-0000-000000006717This is very nice to have. Its just like readymade....

Good stufffffffffffff......

Thnks

Bharath Reddy VasiReddy

]]>Comment Posted by cv_vikramhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 14 Aug 2008 18:26:54 GMT00000000-0000-0000-000000006720thanks....

]]>Comment Posted by djdennihttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseTue, 19 Aug 2008 18:20:15 GMT00000000-0000-0000-000000006721Does anybody know how to convert the following code to VB?

var r = from p in db.Products

       where p.UnitPrice > 15 &&

       p.Order_Details.Sum(x => x.Quantity) < 200

       select p;

Thanks, Dave

]]>Comment Posted by S.Pirashanthhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 28 Aug 2008 03:00:10 GMT00000000-0000-0000-000000006722Many thanks for the great videos

]]>Comment Posted by D' Polygonhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 11 Sep 2008 19:25:24 GMT00000000-0000-0000-000000006723Hello I would really be happy to have this video in VB pls!!!

Thanks so much for the videos you shared.

]]>Comment Posted by vpmraguhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseMon, 22 Sep 2008 09:07:25 GMT00000000-0000-0000-000000006724thank you so much for this video.

]]>Comment Posted by senfohttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseMon, 22 Sep 2008 19:02:00 GMT00000000-0000-0000-000000006725So I didn't really like this one (no offense).  That wasn't a very common update scenario.  How about something a little more common?  For example, open a Product in an Edit page and UPDATE any changes in the database.

]]>Comment Posted by sameeralibhaihttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseFri, 03 Oct 2008 14:45:40 GMT00000000-0000-0000-000000006726That was hilarious (at the end!!) :) Those of us who have kids know how that feels

]]>Comment Posted by gatehyperionhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseTue, 07 Oct 2008 15:15:00 GMT00000000-0000-0000-000000006727Excellent video!  Nice added touch with the sql profiling and perfect comic relief at the end! That was just too dang funny! Since you have that cool voice can you say "I am your father luke" at the end of your next video?

]]>Comment Posted by ASeventhSignhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 09 Oct 2008 16:26:42 GMT00000000-0000-0000-000000006728Love the video...

When the example tried to delete the 'lame' products, I get an Exception:

The DELETE statement conflicted with the REFERENCE constraint "FK_Order_Details_Products". The conflict occurred in database "Northwind", table "dbo.Order Details", column 'ProductID'.

The statement has been terminated.

]]>Comment Posted by PietShttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseTue, 14 Oct 2008 06:33:16 GMT00000000-0000-0000-000000006729I had the same problem as ASeventhSign.

Did we do something wrong? :S

]]>Comment Posted by radu_mhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseMon, 20 Oct 2008 21:48:39 GMT00000000-0000-0000-000000006730This VB Code worked fine for me, i'm showing the TransactionScope to but if you want to have your changes permanently than remove TransactionScope wrapper.

Protected Sub btLame_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btLame.Click

       Using ts As Transactions.TransactionScope = New Transactions.TransactionScope()

           Dim NW As New NorthwindDataContext

           Dim r = From p In NW.Products _

                   Where p.UnitPrice > 15 And _

                   (Aggregate ordQunat In p.Order_Details _

                   Into Sum(ordQunat.Quantity)) < 200

           For Each p As Product In r

               p.ReorderLevel = 0

           Next

           NW.SubmitChanges()

           GridView1.DataSource = r

           GridView1.DataBind()

           Transactions.CommittableTransaction.Current.Rollback()

       End Using

   End Sub

]]>Comment Posted by djibril_chimere_DIAWhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseFri, 24 Oct 2008 06:15:25 GMT00000000-0000-0000-000000006731Thanks !Jërëjëf!

]]>Comment Posted by shinji14http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseWed, 12 Nov 2008 13:45:05 GMT00000000-0000-0000-000000006732Same as ASeventhSign and Piets, this code is supposse to delete also the referencs in orderdetails table?, because is throwing an exception about a foreign key.

]]>Comment Posted by shinji14http://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseThu, 13 Nov 2008 02:56:01 GMT00000000-0000-0000-000000006733well i dont sure if this video was created with a ctp version and this version supported cascade delete, anyway, to solve this activate the cascade option in sql server.

(in "foreign key relationship" window under "insert and update specification" change delete rule to "cascade")

che sos muy comillero xD

]]>Comment Posted by tkfihttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseWed, 03 Dec 2008 21:27:52 GMT00000000-0000-0000-000000006734I see now, that why you sound so cool, hahaha

]]>Comment Posted by nrd1hxwhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseFri, 26 Dec 2008 14:40:57 GMT00000000-0000-0000-000000006735Hi Scott,

Thank you for your great video. I follow your videos to learn Linq. But I have somw problem as ASeventhSign, What I can do for this?  Can I get your answer for him?

My errors as:

"The DELETE statement conflicted with the REFERENCE constraint "FK_Order_Details_Products". The conflict occurred in database "Northwind", table "dbo.Order Details", column 'ProductID'.  The statement has been terminated. "

Also how can  using "SQL Server Profiler as you show us in later Video to catch the regual sql commend? for  db.Products.DeleteAllOnSubmit(r)?  

Thanks

Heng Wang

]]>Comment Posted by dotnetrulerhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseTue, 06 Jan 2009 16:49:48 GMT00000000-0000-0000-000000006736Very good Tutorial... but it would be good if you can spend some more time at the aggregate

]]>Comment Posted by meoden8xhttp://asp.net/web-forms/videos/data-access/how-do-i-with-linq/how-do-i-linq-to-sql-updating-the-databaseTue, 24 Feb 2009 12:15:41 GMT00000000-0000-0000-000000006737When i 've clicked on 'Lame' button, i encountered "DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_Order_Details_Products'. The conflict occurred in database 'Northwind', table 'Order Details', column 'ProductID'.

The statement has been terminated." error. Please help me and sorry about my English.

]]>