Fetch data from database with LINQ.

peter

5y1.1kLINQ

I am looking at the exercise on repeateriterationoncart and trying to impliment same in my project website and when i click on Add in solution explorer to include the Class LINQ TO SQL (DBML file to App_Code folder) it does not exist in my VS 2019.

Is it renamed something else?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
Accepted answer
Hi Peter,

You are welcome!!
Are you using asp.net webforms or MVC?
If you are doing new project then I would suggest that go with Entity Framework with generic repository pattern.
However, Linq tutorial
https://dotnettutorials.net/course/linq/
https://www.codeproject.com/Articles/720471/A-Simple-MVC-Application-using-LINQ-to-SQL

Regards
Rijwan
peter5y ago
I am currently working on own project that access database via procedures and objectdatasource. So in your opinion should i use the LINQ TO SQL file while carry on with this particular project? as i understand from what you mention, the Entity Framework is best started from new project?
peter5y ago
I have been using asp.net webforms.
looking at LINQ to SQL examples it does mention entity frameworks for database access.
Is entity frameworks similar to LINQ to SQL DBML file structure.
peter5y ago
Thanks that was helpful. Can you point me in the right direction on LINK TO SQL learning as i am new to this.
I more use to ADO.NET and want to try using this technology to retrieve data and also manipulate data.
Thanks
Satya Karki5y ago
Hi,

As @rijwan suggested,
You have this component manually. You can find step by step this link
https://www.completecsharptutorial.com/mvc-articles/add-missing-linq-sql-class-vs-2017-2019.php
Rijwan Ansari5y ago
Hi,

First you need to add this component through Visual Stuio Installer from Individual component.
- First Open Visual Studio Installer or (Tool >> Get Tools and Features)
- Select individual tab >> Linq to SQL as shown