Use EF Core 6 db connection in ADO.NET (Microsoft.Data.Sql)

Question

I have an ASP.NET Core application in which I'm using EF Core with MSSQL. In one table of used db there's a column with around 2MB binary data values. Instead of materialising it in memory I'd like to stream that data to the user, so it won't end up in the LOH (Large Object Heap). I've found out that in order to do that I can use ADO.NET as it supports column values streaming.

Most of the time I'm perfectly happy with using EF Core, but in this one case I'd like to fallback to ADO.NET. I know EF Core nowadays depends on Microsoft.Data.Sql instead of System.Data.Sql, so when I found GetDbConnection() (provided in Microsoft.EntityFrameworkCore.Relational assembly) method I expected its return type to be Microsoft.Data.SqlClient.SqlConnection which would play nicely with Microsoft.Data.SqlClient.SqlCommand constructor, but in fact what I'm getting is System.Data.Common.DbConnection.

The question is it possible to transform System.Data.Common.DbConnection (which I'm getting from EF Core) into Microsoft.Data.SqlClient.SqlConnection (which I want to consume using Microsoft.Data.Sql)?

roten · Accepted Answer · 2022-01-21 14:15:49Z

5

Ok, I'm embarassed. Turned out when using Sql you can just cast it directly and it works.

var mdsSqlConnection = (Microsoft.Data.SqlClient.SqlConnection)_dbContext.Database.GetDbConnection();

answered Jan 21, 2022 at 14:15

roten

4202 silver badges16 bronze badges

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

Comments

coolpanchdev · Accepted Answer · 2022-09-28 10:29:11Z

0

var mdsSqlConnection = (Microsoft.Data.SqlClient.SqlConnection)_dbContext.Database.GetDbConnection().Connectionstring;

but password of BD missing in this string

answered Sep 28, 2022 at 10:29

coolpanchdev

11 bronze badge

Collectives™ on Stack Overflow

Use EF Core 6 db connection in ADO.NET (Microsoft.Data.Sql)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related