Using Linq to SQL in asp.net 5 MVC 6

Question

Can I use Linq to SQL in asp.net 5 mvc 6?

There is no "Linq to SQL Classes" in "Add New Item" form

I know its not supported in dot net core 5 but I don't need dnx core 5 and cross platform feature. I'm ok with dnx core 4.5.1

How can I add Linq to SQL Classes file (.dbml) to MVC 6 Project?

There is no error. I just can't find "Linq to SQL Classes" in "Add New Item Page". What is wrong? Screenshot added. — Ali Gonabadi
– Ali Gonabadi, Commented Nov 4, 2015 at 12:23
Probably because LINQ to SQL has been depricated ages ago. You will need to look into using Entity Framework going forwards, if you want to use a Microsoft supported ORM. Is LINQ to SQL deprecated? — Jason Evans
– Jason Evans, Commented Nov 4, 2015 at 12:31

Ali Gonabadi · Accepted Answer · 2015-11-07 16:12:48Z

5

To add Linq To SQL Classes file, you have to add Class Library project to your solution. Now you can add Linq to SQL Classes (.dbml file) to this project.

Then add reference to this Class Library from your main project.

NOTE: you can not use dnxcore 5 in this way. Your main project should use dnx 4.5.1 and class library should use dotNet framework 4.5.1 as target framework.

answered Nov 7, 2015 at 16:12

Ali Gonabadi

9341 gold badge10 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dsm · Accepted Answer · 2020-03-02 11:00:36Z

3

To solve this problem, in VS just go to Tools - Get tools and features - Individual components - Select LINQ to SQL tools and then click on Modify.

answered Mar 2, 2020 at 11:00

dsm

311 bronze badge

Collectives™ on Stack Overflow

Using Linq to SQL in asp.net 5 MVC 6

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related