dotnet/SqlClient issues and pull requests

#1258 - Fix | Revert Event source changes on TryBeginExecuteEvent and WriteEndExecuteEvent to address the failure on other MS products.

Pull Request - State: closed - Opened by JRahnama about 3 years ago - 12 comments

#1256 - .NET 5.0 | Implement the ADO.NET transaction savepoint APIs

Issue - State: closed - Opened by roji about 3 years ago - 2 comments
Labels: :bulb: Enhancement, :new: Public API

#1255 - Manual Test CancelAsyncConnections intermittently fails in worrying ways.

Issue - State: open - Opened by Wraith2 about 3 years ago - 3 comments
Labels: :fearful: intermittent

#1210 - Update `Encrypt` property default value to true

Pull Request - State: closed - Opened by DavoudEshtehari over 3 years ago - 20 comments
Labels: :hammer: Breaking Change

#1206 - Slow read from SqlDataReader

Issue - State: open - Opened by valentiniliescu over 3 years ago - 8 comments
Labels: :chart_with_upwards_trend: Performance, :heavy_check_mark: Repro Available

#1198 - Perf: add allocation free path for close notifications

Pull Request - State: closed - Opened by Wraith2 over 3 years ago - 6 comments

#1191 - WIP | phase 1, adjusting TVP test. Draft PR.

Pull Request - State: closed - Opened by JRahnama over 3 years ago - 1 comment

#1172 - Tests: TvpMain should be split

Issue - State: open - Opened by Wraith2 over 3 years ago - 4 comments
Labels: :heavy_check_mark: Tests

#1158 - Feature: Localized resource support for .NET Core and Standard libraries

Issue - State: closed - Opened by cheenamalhotra over 3 years ago - 1 comment
Labels: :bulb: Enhancement

#1158 - Feature: Localized resource support for .NET Core and Standard libraries

Issue - State: closed - Opened by cheenamalhotra over 3 years ago - 1 comment
Labels: :bulb: Enhancement

#1146 - System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll' In very specific scenario

Issue - State: open - Opened by myurashchyk over 3 years ago - 7 comments

#1126 - .NET Core SqlConnection ConnectTimout 15 less than not work?

Issue - State: closed - Opened by OdaShinsuke over 3 years ago - 5 comments
Labels: :bug: Bug!, netcore

#1116 - System.InvalidOperationException: 'Internal connection fatal error.'

Issue - State: closed - Opened by figueiredorui over 3 years ago - 22 comments

#1108 - Feature | Split Azure dependent functionality in a separate NuGet Package

Issue - State: open - Opened by SimonCropp over 3 years ago - 116 comments
Labels: :bulb: Enhancement, :new: Public API, :hammer: Breaking Change

#1106 - Allow Specifying AAD authentication Methods via ChainedTokenCredential in Microsoft.Data.SqlClient 3.0

Issue - State: closed - Opened by bdschaap over 3 years ago - 7 comments
Labels: :bulb: Enhancement

#1072 - Active Directory Managed Identity authentication method not working

Issue - State: closed - Opened by Yangsh-w over 3 years ago - 28 comments

#1048 - SqlBulkCopy - Leverage Generics to Eliminate Boxing

Pull Request - State: closed - Opened by cmeyertons over 3 years ago - 13 comments
Labels: :hourglass_flowing_sand: Waiting for Customer

#1029 - SqlClient-826 Missed synchronization

Pull Request - State: closed - Opened by jinek over 3 years ago - 15 comments
Labels: :m: Managed SNI

#1027 - Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - Success)

Issue - State: closed - Opened by FIVIL over 3 years ago - 7 comments

#991 - Allow passing null for SqlParameter value

Issue - State: open - Opened by mburbea over 3 years ago - 27 comments

#989 - Authentication provider for 'Active Directory Interactive' should maintain access token cache globally

Issue - State: closed - Opened by Rookian over 3 years ago - 6 comments

#987 - AspNetCore AddHealthChecks().AddDbContextCheck eventually fails with leaked sqlconnections

Issue - State: closed - Opened by mRowlinson27 over 3 years ago - 6 comments

#979 - SqlConnection.OpenAsync() may block on network i/o during connection creation

Issue - State: open - Opened by coderb over 3 years ago - 9 comments
Labels: :chart_with_upwards_trend: Performance

#970 - SqlException: Login failed for user '<token-identified principal>'.

Issue - State: closed - Opened by TresaL over 3 years ago - 4 comments

#969 - .Net 5 published to the ubuntu 20.04

Issue - State: closed - Opened by EminemJK over 3 years ago - 7 comments

#966 - Configurable Retry Logic

Pull Request - State: closed - Opened by DavoudEshtehari over 3 years ago - 39 comments

#960 - Do not truncate given value in exception message for BulkLoadCannotConvertValue

Pull Request - State: closed - Opened by Berreek over 3 years ago - 6 comments

#948 - SqlCommand.ExecuteScalarAsync throw System.NullReferenceException

Issue - State: closed - Opened by TingluoHuang over 3 years ago - 4 comments

#936 - Microsoft.Data.SqlClient.SNI not deployed to _PublishedWebsites for an ASP.NET Web Application

Issue - State: open - Opened by mbakalov over 3 years ago - 16 comments
Labels: :page_facing_up: Native SNI

#919 - System.InvalidOperationException: Internal connection fatal error. Error state: 15, Token : 143

Issue - State: closed - Opened by chaybcr over 3 years ago - 7 comments
Labels: :older_man: System.Data.SqlClient

#917 - Why isn't the Activity API used to track diagnostic events?

Issue - State: closed - Opened by eduard-bystrov almost 4 years ago - 3 comments
Labels: :bulb: Enhancement

#915 - Hangs in ExecuteReaderAsync

Issue - State: closed - Opened by liranc almost 4 years ago - 18 comments

#898 - A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

Issue - State: closed - Opened by rajagopal-p almost 4 years ago - 26 comments

#886 - Hang with SQLClient close connection

Issue - State: closed - Opened by hungdqht almost 4 years ago - 12 comments

#843 - LocalAppContext uses a Dictionary<string, bool> without optimizing for string constants

Issue - State: open - Opened by ASP-WAF almost 4 years ago - 11 comments
Labels: :bulb: Enhancement, :chart_with_upwards_trend: Performance

#826 - Missed synchronization

Issue - State: closed - Opened by jinek almost 4 years ago - 15 comments
Labels: :m: Managed SNI

#822 - SQLConnection GetSchema with PublishTrimmed not working

Issue - State: open - Opened by kblood about 4 years ago - 5 comments

#816 - the maximum size of connection pool is 100 connections but the pending queue keeps growing

Issue - State: closed - Opened by bahadirbal almost 4 years ago - 7 comments
Labels: :hourglass_flowing_sand: Waiting for Customer

#816 - the maximum size of connection pool is 100 connections but the pending queue keeps growing

Issue - State: closed - Opened by bahadirbal almost 4 years ago - 7 comments
Labels: :hourglass_flowing_sand: Waiting for Customer

#810 - ClickOnce Publish not working in .NET Core with Native SNI

Issue - State: closed - Opened by cheenamalhotra almost 4 years ago - 5 comments
Labels: :page_facing_up: Native SNI

#776 - .NET Core and .NET 5 - focal Docker images Won't Connect to SQL Server

Issue - State: closed - Opened by zs-dima about 4 years ago - 35 comments
Labels: :link: External

#775 - Always Encrypted on Serverless functions

Issue - State: closed - Opened by tyler-shuhnicki about 4 years ago - 10 comments

#762 - Publishing .Net Core 3.1 project to windows-server-2016 throws exceptions

Issue - State: closed - Opened by Habdeltawab about 4 years ago - 10 comments

#758 - Question: How to log Datareader or result value via sqlclient diagnostics

Issue - State: closed - Opened by hueifeng about 4 years ago - 6 comments
Labels: :bulb: Enhancement

#745 - Microsoft.Data.SqlClient.SNI.x64 not copied to bin

Issue - State: closed - Opened by LucGosso about 4 years ago - 25 comments
Labels: :link: External, :page_facing_up: Native SNI

#737 - Unable to load DLL 'sni.dll' or one of its dependencies

Issue - State: closed - Opened by SoftCircuits about 4 years ago - 7 comments

#732 - Allow Stream and TextReader to be retrieved by GetFieldValue and GetFieldValueAsync

Issue - State: closed - Opened by roji about 4 years ago - 2 comments
Labels: :bulb: Enhancement

#727 - Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll'

Issue - State: closed - Opened by jonathan-timothy-mason about 4 years ago - 35 comments
Labels: :page_facing_up: Native SNI

#718 - Remove _parsetable from DbConnectionOptions

Pull Request - State: closed - Opened by TrayanZapryanov about 4 years ago - 6 comments

#716 - Poorer performance using BulkCopy.WriteToServerAsync vs WriteToServer

Issue - State: open - Opened by ghost about 4 years ago - 10 comments
Labels: :chart_with_upwards_trend: Performance

#675 - Native libraries not loaded in C# interactive

Issue - State: closed - Opened by mrmonday over 4 years ago - 7 comments
Labels: :page_facing_up: Native SNI

#655 - Add a method to dump connection pool information

Issue - State: closed - Opened by breakpoint7 over 4 years ago - 6 comments
Labels: :bulb: Enhancement

#649 - .NET 5.0 | Implement SqlException.IsTransient

Issue - State: open - Opened by roji over 4 years ago - 19 comments
Labels: :bulb: Enhancement, :raised_hands: Up-for-Grabs

#647 - Execution Timeout Expired Error (258, ReadSniSyncOverAsync)

Issue - State: closed - Opened by frankyuan over 4 years ago - 158 comments

#633 - Error Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)

Issue - State: closed - Opened by machoubie over 4 years ago - 47 comments

#601 - Async opening of connections in parallel is slow/blocking

Issue - State: open - Opened by OQO over 4 years ago - 26 comments

#593 - Reading large data (binary, text) asynchronously is extremely slow

Issue - State: open - Opened by roji over 4 years ago - 178 comments
Labels: :chart_with_upwards_trend: Performance

#583 - SqlConnection.Open() is not finished with success to specified Failover Partner on linux.

Issue - State: closed - Opened by alexanderinochkin over 4 years ago - 12 comments

#534 - Standardize Connection String properties for enhanced user experience

Pull Request - State: closed - Opened by cheenamalhotra over 4 years ago - 3 comments
Labels: :new: Public API

#533 - SqlDataReader.WillHaveEnoughData is pessimistic, can it read ahead?

Issue - State: open - Opened by Wraith2 over 4 years ago - 1 comment
Labels: :bulb: Enhancement, :chart_with_upwards_trend: Performance

#485 - Microsoft.Data.SqlClient.SNI v1.1.1: Still Azure Cloud Service (classic) with EF Core 3.1 => sni.dll not found

Issue - State: closed - Opened by VeselovAndrey over 4 years ago - 14 comments
Labels: :page_facing_up: Native SNI

#449 - Azure SQL: System.ObjectDisposedException: Cannot access a disposed object on OpenAsync

Issue - State: closed - Opened by PashaPash over 4 years ago - 10 comments

#446 - Microsoft.Data.SqlClient.SNI not deployed along with WebForms

Issue - State: open - Opened by jirikanda over 4 years ago - 56 comments
Labels: :page_facing_up: Native SNI

#441 - Microsoft.Data.SqlClient.SNI not deployed along with ClickOnce

Issue - State: closed - Opened by Siam1205 over 4 years ago - 51 comments
Labels: :page_facing_up: Native SNI

#422 - Queries with MultipleActiveResultSets=True (MARS) are very slow / time out on Linux

Issue - State: open - Opened by pawelpabich almost 5 years ago - 106 comments

#412 - Drastic performance difference between using SqlClient and SSMS

Issue - State: closed - Opened by Skyppid almost 5 years ago - 14 comments
Labels: :chart_with_upwards_trend: Performance

#406 - EF Core 3.1.1 TypeInitializationException (SNI)

Issue - State: closed - Opened by rbuskov almost 5 years ago - 10 comments
Labels: :page_facing_up: Native SNI

#384 - WIP: Fix Unicode handling for MAX length N-Character types

Pull Request - State: closed - Opened by cheenamalhotra almost 5 years ago - 1 comment

#381 - Unicode handling differs between NVARCHAR(Max) and NVARCHAR(n)

Issue - State: closed - Opened by hopfen-heiner almost 5 years ago - 3 comments
Labels: :no_entry_sign: Won't Fix

#365 - “Internal connection fatal error” from TdsParser when calling native compiled stored procedure in SQL Server 2019

Issue - State: closed - Opened by Genmutant almost 5 years ago - 26 comments
Labels: :link: External

#359 - Bug | Fix Connection Resiliency for Linux/MacOS clients

Issue - State: closed - Opened by aaomidi almost 5 years ago - 10 comments
Labels: :bug: Bug!

#354 - SNI.dll file locked when ASP.NET (Framework 4.8) App is running in IIS

Issue - State: closed - Opened by jakenuts almost 5 years ago - 88 comments
Labels: By Design, :page_facing_up: Native SNI

#353 - SqlBulkCopy - ReadWriteColumnValueAsync creates lot of garbage

Issue - State: open - Opened by cmeyertons almost 5 years ago - 5 comments
Labels: :bulb: Enhancement

#348 - WIP: Feature | Introduce "Pool Idle Timeout" connection property

Pull Request - State: closed - Opened by cheenamalhotra almost 5 years ago - 1 comment

#343 - Add Pool Idle Timeout to control connection pool

Issue - State: open - Opened by David-Engel almost 5 years ago - 4 comments
Labels: :bulb: Enhancement

#335 - WIP: Improve Async Paths

Pull Request - State: closed - Opened by benaadams almost 5 years ago - 4 comments

#305 - Integrated security - manual kerberos negotiation

Issue - State: open - Opened by aaomidi about 5 years ago - 44 comments

#303 - Remove dependency on .NET Core internal shims

Issue - State: open - Opened by stephentoub about 5 years ago - 5 comments

#290 - Always Encrypted not working in a linux docker container

Issue - State: closed - Opened by hkruijss about 5 years ago - 14 comments

#163 - Please, allow relative path in json ConnectionStrings for AttachDbFilename when using update-database command

Issue - State: closed - Opened by BDisp about 5 years ago - 1 comment
Labels: :bulb: Enhancement

#158 - The type initializer for 'Microsoft.Data.SqlClient.SqlConnection' threw an exception.

Issue - State: closed - Opened by pengweiqhca over 5 years ago - 13 comments

#154 - System.Data.SqlClient is globally resourced. Unable to connect to sqlserver address

Issue - State: closed - Opened by xueandfeng over 5 years ago - 13 comments
Labels: Backport to CoreFx, :older_man: System.Data.SqlClient, Port to NetFx

#148 - SqlDependency Causing Huge amount of Conversation_Endpoints in SqlServer

Issue - State: closed - Opened by ReinhardAmon over 5 years ago - 4 comments

#146 - Wrong isolation level with Sql Azure and TransactionScope

Issue - State: open - Opened by csalvaneschi over 5 years ago - 9 comments

#142 - Add an overload of SqlBulkCopy.WriteToServer that takes an IEnumerable<object[]>

Issue - State: open - Opened by mburbea over 5 years ago - 2 comments
Labels: :bulb: Enhancement

#141 - MARS on and pooling on throws quite a few exceptions in Debian 9

Issue - State: closed - Opened by johnsimons over 5 years ago - 11 comments

#139 - SqlTransaction loosing connection on execution of SqlCommand.ExecuteNonQuery() with exception

Issue - State: closed - Opened by IoBes over 5 years ago - 8 comments
Labels: :bug: Bug!, :raised_hands: Up-for-Grabs

#139 - SqlTransaction loosing connection on execution of SqlCommand.ExecuteNonQuery() with exception

Issue - State: closed - Opened by IoBes over 5 years ago - 8 comments
Labels: :bug: Bug!, :raised_hands: Up-for-Grabs

#136 - SqlBulkCopy: Add RowsCopied Property

Issue - State: closed - Opened by fowl2 over 5 years ago - 3 comments
Labels: :bulb: Enhancement

#126 - Open connection issue on Linux

Issue - State: closed - Opened by sjc9999 over 5 years ago - 44 comments

#120 - Test System.Data.Tests.SqlTypes.SqlDoubleTest.Conversions fails on non english culture

Issue - State: closed - Opened by satano over 6 years ago - 5 comments

#119 - System.Data.SqlClient.ManualTesting.Tests.TvpTest.TestMain fails on Ubuntu due to different regional date format

Issue - State: closed - Opened by keeratsingh over 6 years ago - 4 comments
Labels: Backport to CoreFx

#118 - Microsoft.data.sqlclient fails to connect to local server

Issue - State: closed - Opened by Martin-Stein over 5 years ago - 19 comments
Labels: :link: External

#117 - SqlClient support for Windows on ARM32 for IoT scenarios

Issue - State: closed - Opened by divega over 5 years ago - 2 comments
Labels: :bulb: Enhancement

#113 - Implement async transaction commit/rollback methods

Issue - State: open - Opened by roji over 5 years ago - 4 comments
Labels: :bulb: Enhancement

#105 - SqlClient: Avoid boxing values as much as possible

Issue - State: open - Opened by divega almost 7 years ago
Labels: :bulb: Enhancement, :chart_with_upwards_trend: Performance

#103 - SqlClient gives wrong error with expired or incorrect SQL Server credentials

Issue - State: closed - Opened by albahari almost 6 years ago - 11 comments
Labels: :bug: Bug!

#99 - SqlClient: Keyword not supported: 'TransparentNetworkIPResolution'

Issue - State: closed - Opened by divega over 7 years ago - 9 comments
Labels: :bulb: Enhancement, NetFx :point_right: NetCore

#98 - Convert continuations in SqlClient managed SNI to async/await

Issue - State: closed - Opened by saurabh500 almost 7 years ago - 2 comments

#97 - After SqlException application state is corrupted

Issue - State: closed - Opened by epignosisx about 6 years ago - 25 comments
Labels: :bug: Bug!

GitHub / dotnet/SqlClient issues and pull requests