sqlclient_开发者

What is the difference between System.Data.SqlClient and SQLNCLI10.1 providers?

I\'m connecting my application to a SQL Server 2008 database. What is the difference between the following providers: System.Data.SqlClient provider and SQLNCLI10.1 if the开发者_Go百科re is any?[详细]

2023-03-30 01:48 分类：问答

What does SQL Server return to C#

We can easily work with SQL Server databases with the help of System.Data.SqlClient library in C#. We can return values from stored procedures or we can write sql commands by hardcoding them in C# co[详细]

2023-03-26 03:23 分类：问答

Exception: type initializer for 'system.data.sqlclient.sqlconnection'?

I couldn\'t figure out what is the problem for this exception. The type initializer for \'System.Data.SqlClient.SqlConnection\' threw an exception[详细]

2023-03-25 17:46 分类：问答

SqlDataReader.GetSqlBinary vs SqlDataReader.GetSqlBytes?

Under the namespace System.Data.SqlClient, we have both SqlDataReader.GetSqlBinary 开发者_如何转开发[详细]

2023-03-21 18:58 分类：问答

.NET - SqlConnectionStringBuilder.AsynchronousProcessing

Maybe a silly question, but I\'m wondering why, when using SqlConnectionStringBuilder, I would ever want to make .AsynchronousProcessing false. I\'m sure it\'s my inexperience, but I can\'t figure out[详细]

2023-02-16 11:09 分类：问答

Why can I connect to sql server 2008 via odbc but not through vb.net code?

I\'m supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008.Is there a setting on SQL Server 2008 which will allow ODBC connections to access[详细]

2023-02-03 10:05 分类：问答

timeout sql server on a fast query

I\'m 100% sure that this question is a duplicate but I searched for a few hours and I didn\'t find anything.[详细]

2023-02-03 02:12 分类：问答

SqlException: Timeout Expired

I have a process where two threads are continuously executing sql queries on the same tables. Is there any chance that one of these two threads gets Timeout error? If so, what is the best practice to[详细]

2023-01-21 09:00 分类：问答

SQL Server Command Timeouts Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

we\'ve had a ASP.NET web application deployed for a number of years now.... last week we migrated to a slightly slower server to save some money.[详细]

2022-12-29 10:03 分类：问答

.Net Windows Service Throws EventType clr20r3 system.data.sqlclient.sql error

I have a .Net/c# 2.0 windows service.The entry point is wrapped in a try catch block that notifies me of problems and allows the service to continue operating normally yet when I look at the server\'s[详细]

2022-12-28 20:28 分类：问答