How Do I: LINQ to SQL: Updating the Database

Nice video, bonus with your kid walking in asking to use your computer :D!

nice video. thank you

Would it be possible to get a VB version of this video?

Hi 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

VB PLEASE!!

I agree.  Will the next several be done in VB at some point?

This is very nice to have. Its just like readymade....

Good stufffffffffffff......

Thnks

Bharath Reddy VasiReddy

this is nice

mysearchyard.googlepages.com

this is nice

http;//mysearchyard.googlepages.com

thanks....

Does 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

Many thanks for the great videos

Hello I would really be happy to have this video in VB pls!!!

Thanks so much for the videos you shared.

thank you so much for this video.

So 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.

That was hilarious (at the end!!) :) Those of us who have kids know how that feels

Excellent 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?

Love 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.

I had the same problem as ASeventhSign.

Did we do something wrong? :S

This 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

Thanks !Jërëjëf!

Same 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.

well 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