[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

I see now, that why you sound so cool, hahaha

Hi 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

Very good Tutorial... but it would be good if you can spend some more time at the aggregate

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

thank your video.

http://aveglobal.com

There are two ways you can delete without errors are:

1. you must delete the binding between two tables in the Products and Order_details Northwind.dbml file.

2. Before you delete the data in the Products table you have to order me to remove the ProductID exist in the table Order_detail

Good lucks

There are two ways you can delete without errors are:

1. you must delete the binding between two tables in the Products and Order_details Northwind.dbml file.

2. Before you delete the data in the Products table you must delete the ProductID exist in the table Order_detail

Good lucks

[quote]

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

[/quote]

you need add references System.Data.Linq to namespace, if you use VS 2008, library auto add to namespace.

can you check again version VS.

Good lucks

http://aveglobal.com