sqlconnection
Proper Usage of SqlConnection in .NET
I just want an opinion on the proper usage or a proper design with regards to using SqlConnection object. Which of the 2 below is the best use:[详细]
2023-02-04 03:22 分类:问答C# SQLConnection pooling
Can anyone brief me how to do Connection Pooling in ADO.Net开发者_JAVA技巧, I do need to connect to 3 separate databases. 2 of them are in same server and the other in a separate one.[详细]
2023-01-30 16:13 分类:问答c# closing sqlconnection and sqldatareader or not?
I have this piece of code: SqlConnection conn; string strconString = System.Configuration.ConfigurationManager.ConnectionS开发者_开发技巧trings[\"SQLCONN\"].ToString();[详细]
2023-01-29 04:57 分类:问答Is there a standard .NET way to test if a SqlConnection string works? [duplicate]
This question already has answers here: Closed 12 years ago. Possible Duplicate: How to check if connection string is valid?[详细]
2023-01-28 05:44 分类:问答c# connection to database
I was wondering if it is a good idea to maintain a database connection ( System.Data.S开发者_如何学PythonqlClient.SqlConnection() )open or is it recommended to close the connection after using it and[详细]
2023-01-26 18:07 分类:问答mysql to android using soap
i know very well that android not support the mysql but i need to connect mysql and get the infor开发者_开发技巧mation from database[详细]
2023-01-25 06:45 分类:问答Why does SqlConnection forget the database type
I recently posted (and promptly deleted, when I decided the question was irrelevant to the actual problem) a question about SqlConnection losing its Database information when the scope of \"ChangeData[详细]
2023-01-22 03:21 分类:问答Why both SqlConnection and SqlTransaction are present in SqlCommand constructor?
I wonder, what is the reason to have this SqlCommand constructor overload: public SqlCommand( string cmdText,[详细]
2023-01-21 15:39 分类:问答Altering results prior to using SQLContext.Pipe.Send() in a .NET sproc
Is it possible to edit the data returned from command.ExecuteReader, and then return that to SqlContext.Pipe.Send()?Are there any forseeable issues (I have to reset the cursor to the beginning)?[详细]
2023-01-20 00:19 分类:问答SqlConnection and TransactionScope Timeout
I have a TransactionScope (over DTC,开发者_JAVA百科 read committed) with a timeout of 60 minutes.[详细]
2023-01-17 01:11 分类:问答