LINQ to SQL Videos from the Community

LINQ to SQL Videos from the Community

  • Comments 8

Bill Burrows has done it again and created a series of videos to help get you started with LINQ to SQL in Visual Basic! Bill is a great teacher and the style of these videos is off-the-cuff so that you really feel like you are in a classroom learning real technical content and you're not missing anything. It takes a special kind of person to do this kind of video because personality really shines through. Bill's got a great personality and I'm thankful for the time he's spent on these videos for the Visual Basic Community. I hope you get as much out of these lessons as I did!

Enjoy!

Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post
  • 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

  • Hi Gary,

    I forwarded your comment over to Bill Burrows.

    Cheers,

    -B

  • 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

  • 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

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

  • 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

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

  • 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

Page 1 of 1 (8 items)