I have a fresh Visual Studio 2017 Professional install. I'm building a quick POC Console application using .NET 4.7.1, and I'm unable to find the reference for System.Data.SqlClient. I have scoure...

Since updating Windows 10 to 1803, I have begun receiving this error anytime I run an EF query that joins against a table-valued function that takes in a scalar parameter. Message: The incoming ...

When I run dotnet ef update database I get this error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error...

I am 100% newbie to SQl and wanted to make a ConsoleApp with the use of database. I read some about it and tried. When I needed to make SqlConnection, my VS 2019 Preview showed me this Severity...

Facing following issue after deploying app to azure app service: Unhandled exception. System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, C...

Imagine you have the following scenario: A .net framework 2.0 legacy client app. An SQL Server 2016 Always On Availability Group. How the connection string should be? I can think on two option...

I'm trying to update an MSSQL table using SqlCommand, I think it's a syntax error with my T-SQL, but here is what I have so far: SqlCommand sqlCmd = new SqlCommand("UPDATE yak_tickets SET email = ...

I migrated my project from ASP.NET Core 2.2 to ASP.NET Core 3.0. Now I get this exception. In ASP.NET Core 2.2 it was using FromSql(); now it is using FromSqlRaw(). I am calling my procedure using ...

I have code similar to this running in multiple BackgroundServices (.NET 7). After just a few days of runtime (obviously, delay is in minutes (to hours) between loops) leads to a massive Memory Lea...

I'm getting this System.InvalidCastException a few times a day in a .net 5 ASP.NET web app, but it's not reproduceable on demand. When this error occurs it often seems to happen several times in qu...

C# anonymous types seem really useful, but I've pretty immediately hit upon an application where I would like to set the property of an anonymous type, and I'd also like to be able to use attribute...

After upgrading to Microsoft.Data.SqlClient Version=4.0.0 got the error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...

I'm trying to run my azure function application as a docker image and when I do it throws me a System.PlatformNotSupportedException in Microsoft.Data.SqlClient.dll: 'Strings.PlatformNotSupported_Da...

I have a busy ASP.NET 5 Core app (thousands of requests per second) that uses SQL Server. Recently we decided to try to switch some hot code paths to async database access and... the app didn't eve...

My web site was working flawless in the old Host, But now i Moved to a new host Please pay attention: The Old host was a VPS on the same host So i'v stoped paying him and now i'm hosting on the s...

I am developing several ASP.NET web services that use SQL Server for storage and Azure Application Insights for telemetry. I was not getting full SQL command text in the dependency telemetry when r...

After fixing my problem as mentioned here I am getting the below exception System.IO.FileNotFoundException: 'Could not load file or assembly 'System.Data.SqlClient, Version=4.1.0.0, Culture=neut...

I couldn't figure out what is the problem for this exception. The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception First attempt: I was using the WCF Service to make ...

I am trying to use SQLClient library in the ASP.net Core but cant seem to get it working. I found this article online advising how to setup but its not working for me: http://blog.developers.ba/usi...

When making calls to SQL Server that actually do things that take time, SqlDataReader.ReadAsync() runs synchronously for me. Is there any way to force it to run asynchronously or is my only option ...

So, want to make a multi-row insert query, and I need to replace the keys with the values inside a loop where I have the values. It was working by hardcoding the values into the query string, but ...

I have an application which would read data from SQL and send it via WCF to a client app, in a manner similar to this: SqlDataAdapter da = new SqlDataAdapter( cmd ) DataSet ds = new DataSet(); da....

I am getting version conflict error when using System.Data.SqlClient.dll in .Net Core 2.0. Its look like conflict between Core dll and NetStandard dll. Not sure why referring "System.Data.SqlCl...

I have a .NET Standard 2.0 class library project with installed Nuget package System.Data.SqlClient version 4.4.0 and a Windows Form .NET Framework 4.7 project that has a reference to that class li...

I have the following C# code that executes against a SQL Server hosted in Azure. protected IQueryable<T> FilterUpdatedRows<T>(IQueryable<T> query, DateTime lastSyncTimestam...