How to use ADO.NET asynchronous methods in .NET Core without Entity Framework

asp.net-core asp.net-core-webapi entity-framework-core

Question

I believe Entity Framework Core is slow for the application that I am working on. It is a .NET Core Web API. I need to convert it to use ADO.NET and at the same time take advantage of asynchronous programming that is easy in Entity Framework Core. Any resources or direction will help me kick start my migration.

1
0
5/8/2018 9:03:38 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I haven't tested it, but something like this would allow you to use ADO.NET objects:

var con = ctx.Database.GetDbConnection();
var cmd = con.CreateCommand();
cmd.CommandText = "...";
var rdr = await cmd.ExecuteReaderAsync();
1
5/8/2018 9:53:40 PM

Related Questions

ADO.NET provider with invariant name 'System.Data.SqlClient;' cannot be found (Entity Framework MVC)

I cannot seem to resolve what appears to be a common issue with Entity Framework 6. I have reviewed the many topics related to this issue on SO, and am unable to find a solution that works for my particular case....I have up until this point been developing using localdb with code first migrations, which worked fine. But now that I am moving this t...
.net asp.net asp.net-mvc entity-framework entity-framework-6
asked by Rasen244

ADO.NET Entity Framework - Oracle with Entity Framework 6

I'm trying to add an ADO.NET Entity Data Model to my solution which uses an Oracle database (ODP.NET), but I get the following error:..."Your project references the latest version of Entity Framework; however, an Entity Framework database provider compatible with this version could not be found for your data connection. If you have already i...
asp.net-mvc entity-framework entity-framework-6 oracle
asked by dev0007

How to make asp.net core rc2 (.net framework) work with EF 7 and .net 4.61

I have created an asp.net core RC2 (.NET 4.61 framework) project....Then I have created another "DataProvider" nuget class library (.NET core) with Entity Framework references and changed the ...framework... in the ...project.json... settings to ..."net461":{}.......The reason why I did not create a common c# class library because it has no project...
asp.net-core entity-framework-core
asked by Elisabeth

Entity Framework Core get entity without related entities

I've been searching a bit on this but thus far haven't been able to find a decent solution. I'm trying to get an entity from my database without the related entities attached to it....The function goes as following ...return context.Entity.SingleOrDefault(n => n.Name == name)... where ...context is a DbContext.......As of now the reply contains onl...
c# dbcontext entity-framework-core
asked by Haraldur

Moq and Entity Framework Core do not really work with asynchronous methods?

I'm trying to create a test repository using Moq with EF Core, using its asynchronous methods (like ...AddAsync... and ...SaveChangesAsync...), but I have not had the slightest success ......I've found many and many blog posts (including questions here), but nothing works for me....For example, I literally copied the code from this article and trie...
.net-core c# entity-framework-core mocking moq
asked by GustavoAdolfo

How to install entity framework core to asp.net core 3 project using visual studio code

I'm creating a new MVC application using visual studio code and I want to add entity framework core to my project. My application is using the latest .net core 3 but when I tried to install package ...Microsoft.EntityFrameworkCore.SqlServer... its show an error like this ...Unable to resolve 'Microsoft.EntityFrameworkCore.SqlServer (>= 3.0.0)' for ...
asp.net-core c# entity-framework-core visual-studio-code
asked by codeken

C# .NET Core EF or ADO.NET query takes minutes and SSMS just 30 seconds, why?

So yeah, I'm currently stuck on a simple code that my app should do pretty quickly, considering the same query runs in SSMS in about 34 seconds and uses around 90mbps:...But then, look at what EF does while running the same query:...Not even using ADO.NET makes it go as fast as SSMS. What gives? I've yet to try this with .NET Framework. Currently u...
ado.net database-performance entity-framework-core networking ssms
asked by DARKGuy

Using EF from asp.net core and .net framework app

is it possible to have a common code base for model / context / migrations to use the same SQL DB from asp.net core app (3.1) and .net framework app (4.6.1)? My attempts failed. Is there no other solution than creating two projects, one with EF core in .net core 3.1 assembly and one with EF6 with target 4.6.1....I tried to create a .net standard 2....
.net-standard asp.net-core c# entity-framework entity-framework-core
asked by Mustafa

Migrate .NET Core 2.2 to .NET Core 3.1 and keep referencing EF Core 2

I have a C# application written with .NETCore 2.2 and Postgres and I would like to migrate it to .NET Core 3.1....The problems is that there are so many breaking changes, especially in Entity Framework that it is not possible to rewrite everything now. At the same time, other developers continue development on .NET Core 2.2 branch and I need to do ...
.net-core .net-core-3.1 c# entity-framework-core
asked by Tomas Kubes

Unable to send array data using ajax with ASP.NET Core and Entity Framework Core

I am trying to send array to the controller but it's blank in the controller parameter....Ajax function is:...$('#pending').click(function () { SaveTestResult("/Reception/PatientTests/SavePendingTest"); }); function SaveTestResult(url) { var pid = $('.patientId').attr('id'); var tid = ""; var tval = ""; var tpid = ""; var t...
asp.net-core asp.net-core-2.0 asp.net-mvc entity-framework-core
asked by SK jha

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow