LINQ to SQL Videos from the Community

Comments

# Gary said on August 22, 2007 8:48 AM:

Hi Beth

I'm having trouble with these video. The screens do not render correctly (image is badly skewed). Getting audio ok. I'm using IE 7.0.5730.11  Same problem with the lastest version of Firefox.

Any ideas?

TIA

Gary

# Beth Massi said on August 22, 2007 11:56 AM:

Hi Gary,

I forwarded your comment over to Bill Burrows.

Cheers,

-B

# bill burrows said on August 23, 2007 9:03 AM:

Gary's problem appears to related to his OS (Windoes XP Home). We are working on a fix and I'll post it here when we get it figured out.

bill burrows

# bill burrows said on August 31, 2007 11:53 AM:

Regarding Gery's problem -- we were unable to resolve his issue viewing the videos with Windows XP Home edition. I have made Flash videos for him that work. If you have a similar problem. contact me from the myVBProf.com web site (Contact Us page).

bill burrows

# Gimmy said on September 19, 2007 3:08 PM:

Hi

Thanks for the videos. It beats reading books.

I was going about video #9 (Adding Validation) and I noticed that you use datatable events in the partial class.

Since you are using VB.NET it is fine, but I used C#.NET and I did not get the same datatable events you had (columnchanged, newrow) showing on the editor. In fact they are defined in the class but not activated and don't appear in the editor's drop downs.

I guess your focus is in VB but you may be able to answer my quesiton or direct it to  someone else who could help.

Thanks.

# Ron Nash -England said on January 26, 2008 5:02 PM:

Have just finished viewing Bill's on-line videos and coding my own test projects based on these videos. Just like to say  thanks to Bill, I found them excellent and easy to follow. Bill your students are right when they said to leave in the errors  and comments associated with them, it adds abit of humour and real life to it.

Many Thanks and look forward to many more of your learning videos.

Ron - England

# Ron Nash said on January 30, 2008 5:55 PM:

Have been using Bill's learning videos on LINQ to SQL, it seems that some of the methods have changed, for example, the ' add ' and 'removeall' to

' InsertOnSubmit ' and DeleteOnSubmit.

I have the following issue with bill's example to delete arecord but now using the DeleteOnSubmit method. The line db.replemishes.DeleteOnSubmit(aitem) errors :Option Strict On disallows implicit conversions from 'System.Linq.IQueryable(Of WindowsApplication1.replemish)' to 'WindowsApplication1.replemish'.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

       Dim aitem = From d In db.replemishes _

                   Where d.partno = "AAAAA" _

                   Select d

       db.replemishes.DeleteOnSubmit(aitem)

       db.SubmitChanges()

   End Sub

End Class

How do I resolve this please?

# burrowsuw said on January 31, 2008 9:32 AM:

To solve Ron's problem, you need to get a specific object from the enumeration of objects in the query. The example below converts the enumeration into a list of objects and then takes the first (and only in this case) object to be used in the delete method.

Code:

   Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click

       Dim customer = From c In db.Customers _

              Where c.CustomerID = "AAAAA" _

              Select c

       ' old code - does not work in RTM

       'db.Customers.RemoveAll(customer)

       Dim custList = customer.ToList

       db.Customers.DeleteOnSubmit(custList(0))

       db.SubmitChanges()

       Me.CustomerDataGridView.DataSource = db.Customers

   End Sub

Leave a Comment

Name (required) 

Your URL (optional)

Comments (required) 

  

Enter Code Here: Required

Remember Me?

About Beth Massi