ado.net_开发者

Run stored procedure in C#, pass parameters and capture the output result

This is a simple task that I want to acheive but ASP.NET makes it quite difficult, next to impossible. I followed this question[详细]

2023-04-13 09:32 分类：问答

how to replace code that uses now obsolete System.Data.OracleClient namespace classes?

I\'ve made a \"generic\" program that converts data from a db to another. It uses configuration files to define the conversion. It uses code like this:[详细]

2023-04-13 06:31 分类：问答

Unusually long pause trying to close ADO.NET connection object: is this normal?

I am performing a simple exercise of opening an SQL Server database connection, pulling the first record of a table from a DataReader object, and then closing the object.However, I have noticed that t[详细]

2023-04-13 06:17 分类：问答

ASP.NET MVC Database connectivity using ADO.NET

I\'m new to ASP.NET MVC. I want to work with SQL Server database with stored procedures without using LINQ but standard ADO.NET. How can I do that? Is there any useful开发者_JAVA技巧 video tutorial or[详细]

2023-04-12 23:43 分类：问答

Executereader and execute non-query in a single connection in ado.net

The below snippet employs multiple queries inside the same connection string. first i\'m selecting the some datas from the DB then before closing the datareader(dr) i would like to do some validations[详细]

2023-04-12 15:29 分类：问答

Query executed from Nhibernate is slow, but from ADO.NET is fast

I have a query in my MVC application which takes about 20 seconds to complete (using NHibernate 3.1). When I execute the query manually on Management studio it takes 0 seconds.[详细]

2023-04-12 14:24 分类：问答

Strange memory leak related to DataContext and PropertyChanged event

I have a windows service written in C#. After running for a couple of days it will be using about 2GB of ram.[详细]

2023-04-12 12:59 分类：问答

Portibility concern in a c# and ado.net application

greetings to all the members for taking time to read this question. I am preparing an application for a quiz system that will take random questions from the database and put them in the i开发者_JAVA技[详细]

2023-04-12 11:40 分类：问答

C# Data Set Method

In my C# program, I have several areas where I am connecting to an excel spreadsheet.To reduce repeat of coding, I am trying to write a method that reads in an sql statement, and then outputs a datase[详细]

2023-04-12 05:24 分类：问答

populating an Entity DataModel from XML using Linq

I have a C# .net 3.5 application using an ADO.NET Entity D开发者_JAVA技巧ata Model. I am loading the contents for a given database entry from an XML file.[详细]

2023-04-11 18:37 分类：问答