The ado.net tag has no wiki summary.
13
votes
3answers
2k views
Why is `SELECT @@IDENTITY` returning a decimal?
I'm using Dapper to execute the following query against a SQL Server 2008 R2 Express instance from a ASP.NET MVC 3 (.NET 4.0) application.
INSERT INTO Customers (
Type, Name, Address, ...
7
votes
1answer
1k views
What is the “Chaos” Isolation level and when should it be used?
ADO.NET documentation shows the possibility of setting the transaction level for a SQL transaction to Chaos. It sounds unpleasant, but if the feature is there, presumably it has some legitimate use.
...
6
votes
2answers
2k views
Trouble deciphering a deadlock in an innodb status log
We are accessing MySQL from the Microsoft ADO.NET connector.
Occasionally we are seeing the following deadlock in our innodb status and haven't been able to identify the cause of the problem. It ...
4
votes
3answers
807 views
Is the ADO.NET Entity Framework known for generating poorly performing queries?
This question is inspired by the comment posted to the latest ServerFault blog post:
Are you guys still using LINQ to SQL?
I know I can use SQL Server Profiler and/or the ToTraceString method to ...
3
votes
2answers
2k views
Will these two queries result in a deadlock if executed in sequence?
This is almost certainly the cause of my other question, but I thought it was worth separating the two as I have a hypothesis based on the following log that I would love to have falsified or ...
2
votes
2answers
1k views
How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?
In my oracle Database if have the following table:
Create table Test_call_count (
count number(10)
);
insert into Test_call_count values (0);
Now I can run the following PowerShell script
if ...
2
votes
0answers
27 views
Failover only working for Classic ASP, not ASP.net
Setup:
All machines run Windows Server 2008 Enterprise
SQL Server 2012 Standard (Primary)
SQL Server 2012 Standard (Mirror)
SQL Server 2012 Express (Witness)
Root issue: Our ASP.NET application is ...
1
vote
1answer
849 views
What is the purpose of sqlbulkcopy's useinternaltransaction property?
I'm just testing my PowerShellScript to do bulkcopy of multiple tables between sql-server and oracle Databases.
When the destination is Oracle, than I can monitor the progress by by executing
select ...
1
vote
0answers
34 views
Application using DB2 not launching due to Win 8
My application uses DB2. It is working fine in Win 7, but not launching in Win 8.
Giving error
System.Configuration.ConfigurationErrorsException:
Failed to find or load the registered .Net ...
1
vote
0answers
223 views
Which are the Oracle basics required for advanced Oracle.DataAccess usage? [closed]
Successful use of [Oracle.DataAccess.Client] is based on proper understanding of three separate parts of Oracle:
SQL
PL/SQL
sql*plus
Here on dba.exchange the following questions target this topic:
...
0
votes
3answers
379 views
SSIS 2008 painfully slow to import CSV
I am using SSIS to import a 25,000 row CSV to an empty table. The table has a primary key that is populated as the data is inserted. I am using an ADO.Net destination.
What reasons are there why ...
0
votes
1answer
209 views
Creating a bar chart from datatable
I'm writing a console application that fetches data from database (SQL) and writes to an excel sheet. Now I want to add a chart in the workbook according to the datatable values. How can I create ...
0
votes
2answers
93 views
Understanding the use of Sql command parameters
I am using MySql database and I have a stored procedure to insert data, like this-
CREATE DEFINER=`root`@`localhost` PROCEDURE `adduser`(
IN id varchar(10),
IN pwd varchar(10),
IN fname ...
0
votes
1answer
502 views
32-bit versus 64-bit ODP.NET to Oracle connection
I seem to be having an issue connecting a 32-bit .NET application to a 64-bit server, without a full Oracle client.
If I build a 64-bit application, using the 64-bit ODP.NET dll's or a 64-bit instant ...
