sqlconnection
Why my SqlConnection hang forever when working with NHibernte + Spring.Net
I wrote an test case extending the Spring.Net\'s AbstractTransactionalDbProviderSpringContextTests class and trying to do something like this.[详细]
2023-01-15 12:42 分类:问答Will SqlConnection get disposed by GC?
Disclaimer: I know IDisposable should be implemented when dealing with unmanaged resources.The rest of the code should be deterministic and do using (...) { } (equivalent of try {} finally { Dispose()[详细]
2023-01-14 23:07 分类:问答C# DbConnection cast to SqlConnection
I found this piece of code in one application Database database = DatabaseFactory.CreateDatabase(\"connection string\");[详细]
2023-01-14 18:09 分类:问答multiple sqltransactions in single sqlconnection
I have some code that I want to execute as follows. But I keep getting the exception \"This SqlTransaction has completed; it is no longer usable\" on the 2nd iteration. Could someone help me point out[详细]
2023-01-13 02:50 分类:问答savepath? saving excel to sql?
I\'m really confused on how to go about doing this. I want to be able to upload an excel sheet from my web app using the[详细]
2023-01-11 06:14 分类:问答Disposing of static resources in web service
In a pre-WCF .NET (C#) web service, I have 开发者_如何转开发an expensive IDisposable resource that I\'m holding a static (actually ThreadStatic) reference to. (Internally it holds a SqlConnection.) Ho[详细]
2023-01-11 06:02 分类:问答What is the relationship between open SqlConnections in the client app and processes in SQL Server?
I just tried to make a simple schema change to a table in a SQL Server database (by using the Design tool in SMSS). Whenever I tried to save the change, it kept timing out. I wondered whether this was[详细]
2023-01-11 05:15 分类:问答Which pattern is better for SqlConnection object?
Which pattern is better for SqlConnection object? Which is better in performance? Do you offer any other pattern?[详细]
2023-01-09 22:22 分类:问答sql connection on c# smartdevice application
I\'m trying do build an application using the pocket pc emulator... My goal is to connect to a sqlserver express db placed onto another pc[详细]
2023-01-07 07:27 分类:问答Calling sqlCommand in a loop increasing exec time every step
I\'ve got a loop that executes the stored procedure in a loop with over 40,000 iterations, like so: SqlCommand command = new SqlCommand(\"WriteDataToDB\");[详细]
2023-01-06 01:33 分类:问答