How do I run my .sql script file through ADO.NET?
I want to run my .sql script file using my ASP.NET website through ADO.NET. How it could be it is not working?
sql
Best way to improve performance (and include somehow failover)
We have an application running where IIS and SQL are on the same machine. It’s a windows2003standard server, with 4gigs of RAM running on a VM.
Pass a NULL in a parameter to a DateTime field in a stored procedure
I have a stored procedure which updates a database using the parameters I supply but I’m having trouble passing a NULL to the stored procedure
Ordering SQL Server results by IN clause
I have a stored procedure which uses the IN clause. In my ASP.NET application, I have a multiline textbox that supplies values to the stored procedure. I want to be able to order by the values as they were entered in the textbox. I found out how to do this easily in mySQL (using FIELD function), but not a SQL Server equivalent.
Cannot insert explicit value for identity column in table ‘ClientDetails’ when IDENTITY_INSERT is set to OFF
I get this exception thrown whenever I try and submit data through a form to this database :-
How to Delete multiple records in Linq to Entity?
I have a tblA in sql: id int (primary key) fid int data in tblA is: 1 1 2 1 3 2 4 2 5 3 6 3 i delete one record by following code: DatabaseEntities obj = new DatabaseEntities(); int i = 2; tblA t = obj.tblA.Where(x => x.fid == i).FirstOrDefault(); obj.DeleteObject(t); obj.SaveChanges(); i … Read more
ASP.NET – Storing SQL Queries in Global Resource File?
Is it a good idea to store my SQL queries in a global resource file instead of having it in my codebehind? I know stored procedures would be a better solution but I don’t have that luxury on this project.
ASP.NET ConnectionString AttachDbFilename=|DataDirectory|
This is about ConnectionStrings / ASP.NET MVC with Visual Studio 2012 ultimate & SQL Server Express 2012.
Execution of the command requires an open and available connection. The connection’s current state is broken.
After some use in qa we get the following error
Time out period not elapsed, but still timing out (see code)?
OK I keep getting this error after about 3-4 minutes of churning: