none
More Information regarding Linq for beginners to professionals RRS feed

  • Question

  • Hello,

    I took courses Database Information Systems using Microsoft Access and Visual Basic Version 6 from a community college back in the early 2000s.

    From there, slowly, I have migrated from Visual Basic Version 6 to Visual Basic.NET.

    This year, on my own still, I want to migrate from ADO.NET and Access SQL to LINQ which could be an easier database language to understand.  Increasingly, I am interested; however, I do not have enough resources related to LINQ programming.

    Where do I begin, and which detailed LINQ related tutorials please?

    Regards,

    JohnDBCTX


    jp

    Friday, August 4, 2017 10:00 AM

All replies

  • This year, on my own still, I want to migrate from ADO.NET and Access SQL to LINQ which could be an easier database language to understand.

    Linq is not a DB language. Linq allows a developer to query a querable datasource.

    http://searchwindevelopment.techtarget.com/definition/LINQ

    You best learn about Linq in general before using Linq to query a DB. The best I can tell you is go get a good book on Linq. I learned Linq from the C# Linq in Action book many years ago. The book below in VB.NET should get you started.

    https://www.amazon.com/Pro-LINQ-VB8-Language-Integrated/dp/1430216441

     
    Friday, August 4, 2017 8:56 PM
  • Hi JohnDBCTX,

    >>Where do I begin, and which detailed LINQ related tutorials please?

    As far as I know that LINQ to SQL or entity framework does not support Microsoft access. I would suggest that you could migrate your database to localDB or SQL Express.

    In addition, I would suggest that you migrate your app to entity framework, because LINQ to SQL is a legacy ORM that Microsoft provides.

    For LINQ, you could refer to the following document.

    https://docs.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/linq/introduction-to-linq

    For entity framework, you could refer the following document to get started.

    #EF6

    https://msdn.microsoft.com/en-us/library/aa937723(v=vs.113).aspx

    #EF Core

    https://docs.microsoft.com/en-us/ef/core/

    Best regards,

    Cole Wu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, August 7, 2017 9:33 AM
    Moderator