Camillia

<div>
EF creates extra joins and needs performance tuning. I want to have control over my Data Access Layer. with Linq to SQL, I created stored procs and used the context. I'm sure I can do the same with EF but EF is not complicated. We have a lot of performance issues at work now.<br />
<br />
I'll check out the link, but any other options besides EF?
</div>


EF creates extra joins and needs performance tuning. I want to have control over my Data Access Layer. with Linq to SQL, I created stored procs and used the context. I'm sure I can do the same with EF but EF is not complicated. We have a lot of performance issues at work now.

I'll check out the link, but any other options besides EF?

<div>
<div class="content wysiwyg-content">
I have legacy code in C#, Web Forms and <b>LINQ to SQL</b>. <br />
<br />
I want to upgrade this code and I want to move the data layer to ASP.Net Web API. I found this link<br />
<a href="https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-2.1" rel="ugc">https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-2.1</a><br />
<br />
I wanted to keep LINQ to SQL code (DBML) to make the upgrade go faster. Looks like LINQ to SQL is not supported in .Net Core.<a href="https://stackoverflow.com/questions/51671408/linq-to-sql-tools-how-to-use-it-with-asp-net-core-2-1-project" rel="ugc">L2S not supported lin</a><br />
<br />
What should I do? I have DBML, stored procs. How can I do my upgrade?
</div>
</div>


I have legacy code in C#, Web Forms and LINQ to SQL. 

I want to upgrade this code and I want to move the data layer to ASP.Net Web API. I found this link
https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-2.1

I wanted to keep LINQ to SQL code (DBML) to make the upgrade go faster. Looks like LINQ to SQL is not supported in .Net Core.L2S not supported lin (https://stackoverflow.com/questions/51671408/linq-to-sql-tools-how-to-use-it-with-asp-net-core-2-1-project)

What should I do? I have DBML, stored procs. How can I do my upgrade?

ASP.Net core doesn't support LINQ to SQL?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).