Need help learning to manipulate SQL Server db with VS2013 VB.net

• ssal

  SSC Enthusiast

  Points: 135

  More actions

  May 14, 2015 at 10:56 pm

  #308131

  I am quite fluent with VB6/VBA and Access and had written code in a few projects with those.

  I am migrating to VS2013 VB and SQLExpress. I went thru James Foxall's "Teach Yourself VS 2012" and start to get a feel of it. But there is only one chapter dealing with db/sql. I found his sample codes are very cumbersome. I searched the web and found some codes a lot more efficient, and quite similar to the old tools I know. But searching in the web is not organized.

  Is there some sites or tutorials that deal with this specific subject (as titled of this thread)?

  Would appreciate some pointers.

• serg-52

  SSCrazy Eights

  Points: 9913

  More actions

  May 15, 2015 at 3:05 am

  #1798115

  MSDN has ADO.NET Code Examples https://msdn.microsoft.com/en-us/library/dw70f090(v=vs.110).aspx to start with.

  First look at SqlClient namespace which is ADO.Net specific toolset for MS SQL DBs.

  Having already done some Db related projects you most probably worked with DataSets, which is the next step otherwise.

  Them you may wish to proceed with EF and LINQ.