ado.net
How to test if a connection to a Db is established successfully?
I want to write a unit-test which asserts a connection string is valid so that a conenction is established to a SQL Db.[详细]
2023-04-07 19:56 分类:问答Unable to display SQL database data on Visual basic form
I am facing a problem displaying the records of my table on the visual basic form I have created. This is my code :[详细]
2023-04-07 18:42 分类:问答NHibernate and ADO.NET Connection Pooling
It seems that NHibernate does not pool ADO.NET database connections. Connections are only closed when the transaction is committed or rolled back. A review of the source code shows that there is no wa[详细]
2023-04-07 16:41 分类:问答How to send a table-type in parameter to T-SQL while using C# IDataReader?
I wrote a t-sql sp that gets a table as parameter. I tried to call it from c#, but didn\'t know what type to use:[详细]
2023-04-07 15:46 分类:问答.Net - ado.net importing rows vs adding rows?
The DataTable has a method called ImportRow(), There is also 开发者_Go百科a method unders the rows called Add(). So what\'s the difference between these methods?[详细]
2023-04-07 13:40 分类:问答More than 100 connections to sql server 2008 in "sleeping" status
I have a big trouble here, well at my server. I have an ASP .net web (framework 4.x) running on my server, all the transactions/select/update/insert are made with ADO.NET.[详细]
2023-04-07 12:59 分类:问答Is it better to use linq2sql to generate classes for stored procedures, or to call the stored procedures directly?
I see tons of questions on LINQ to SQL vs Stored Procs. I\'m more curious about the benefits of using them in tandem as relates to object mapping.[详细]
2023-04-07 12:24 分类:问答Informix can't connect via IBM.Data.Informix
I\'m trying to connect to Informix database using sample code from https://www.ibm.com/developerworks/data/library/techarticle/dm-0510durity/[详细]
2023-04-07 09:12 分类:问答can't add a .accde MS access file(located outside the project folder) as AccessDataSource
I\'m pretty sure that the .accde file does exist. I noticed that V开发者_Python百科S asks for .mdb file, but a .accdeis also a MS Access generated database file.[详细]
2023-04-07 04:53 分类:问答Call a stored procedure with parameter in c#
I\'m able to delete, insert and update in my program and I try to do an insert by calling a created stored procedure from my database.[详细]
2023-04-07 01:09 分类:问答