datareader

Output parameters not readable when used with a DataReader

When using a DataReader object to access data from a database (such as SQL Server) through stored procedures, any output parameter added to the Command object before executing are not being filled after reading. I can read row data just fine, as well as all input parameters, but not output ones. [This question is actually just for anyo...

.NET DataTable skips rows on Load(DataReader)

I'm trying to populate a DataTable, to build a LocalReport, using the following: MySqlCommand cmd = new MySqlCommand(); cmd.Connection = new MySqlConnection(Properties.Settings.Default.dbConnectionString); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT ... LEFT JOIN ... WHERE ..."; /* query snipped */ // prepare data dat...

SqlDataReader: In this scenario, will the reader get closed?

I am cleaning up the DataReaders in an old .NET 1.1 project that I inherited. The previous developer coded the data-access-layer in such a way that most of the DAL methods returned SqlDataReaders (thus leaving it up to the caller to properly call the .Close() or .Dispose() methods). I have come across a situation, though, where a cal...

SQL DataReader missing a row in loop

When running the following code it leaves out one row. When I do a files.Count it says there are 4 rows but there is no data stored for the 4th row. When I run the stored procedure from within SQL Manager it returns all 4 rows and all the data. Any help? List<File> files = new List<File>(); SqlConnection active_c...

How do I mock the method GetValues() in System.Data.IDataReader?

How do I mock the method GetValues() in System.Data.IDataReader? This method changes the array of objects passed to it, so it can’t simply return a mocked value. private void UpdateItemPropertyValuesFromReader( object item, IDataReader reader ) { object[] fields = new object[ reader.FieldCount ]; reader.GetValues( fields ); //...

Is datareader quicker than dataset when populating a datatable?

Which would be quicker. 1) Looping a datareader and creating a custom rows and columns based populated datatable 2) Or creating a dataAdapter object and just (.Fill)ing a datatable. Does the performance of a datareader still hold true upon dynamic creation of a datatable? ...

Datareader returns no results in VS yet Stored Procedure returns multiple result sets in Sql Server

I am having trouble retrieving results from my datareader in visual studio 2008. I have several stored Procs in the same database. I am able to retrieve values from those that dont receive input parameters. However, when i use the executreReader() method on a stored proc with input parameters i get an empty datareader. Upon examining the...

Check for Existance of column in DataReader OR Not make debugger break on certain exceptions

I have code that looks like: //System.Data.IDataRecord dr try { Consolidated = Utility.NullConvert.ToBool(dr[Constants.Data.Columns.cConsolidated], false); } catch (IndexOutOfRangeException) { } //swallow I don't know if the consolidated column will be present in the datareader, so I do that to check, works fine (little hackish...

Strange results from OdbcDataReader reading Sqlite DB

This method returns some strange results, and was wondering if someone could explain why this is happening, and possibly a solution to get my desired results. Results: FileName = what I'd expect FileSize = what I'd expect Buffer = all bytes = 0 BytesRead = 0 BlobString = string of binary data FieldType = BLOB (what I'd expect) Co...

"The wrong number of parameters does not match number of values for stored procdure" System.Data.Common.DbCommand nuance.

This could be an sql server database setup issue, but I am not to sure where to start looking. I have a stored procedure : CREATE PROCEDURE aStoredProcedure @dteSince DATETIME = null AS ... The c# code to call the stored procedure is :- using (IDataReader dr = database.ExecuteReader("aStoredProcedure")) { ... The c# code works fin...

How to easily convert a DbDataReader object into something useful?

I am manually calling a stored procedure using an Entity Framework EntityConnection like so: DbConnection storeConnection = entityConnection.StoreConnection; DbCommand command = storeConnection.CreateCommand(); command.CommandText = "sp_GetMyComplexData"; command.CommandType = CommandType.StoredProcedure; DbDataReader reader = command....

.NET object hydration from IDataReader slow performance

I am trying to hydrate a list of ~400 business objects and the performance becomes very slow when it needs to hydrate strings. It's taking in excess of 20secs to hydrate the 400 objects. EDIT We are using MySQL 5.1 and dotConnect for MySQL v5.0.12 as the data provider http://www.devart.com/dotconnect/mysql/ I did some benchmarks to na...

How To: Use a datareader without a count of records

It seems folks have lost the ability to generate old style COBOL/RPG reports using modern day languages. I often see code using DataReaders that relies on a count of records. So an additional aggregrate query is present when it need not be. In most circumstance this code needs to know if there is another record available or not. In o...

Using ASP.NET MVC without an ORM

In my ASP MVC application I'm using standard SQL (rather that Linq to SQL or other ORM) to query my database. I would like to pass the database results to my view and iterate over the results in my view. But I'm not sure how to do this. Every example I've seen passes some string or uses L2S. I would like to pass something like neste...

Stored proc Output parameter + Select not passing back output parameter

Hi I have a stored procedure that returns two recordsets which i call using GetReader. I iterate the first, call IDataReader.NextResult(), then iterate the second. I assign values to output parameters in the sp, but when i check the values after finishing with my reader, my output parameters are null. Looks like a bug. I don't want to ...

SqlDataReader executing TSQL is faster than management studio executing TSQL

If i run a TSQL Statement in management studio and run the same the query through SqlDataReader, the latter gives the result faster than the former... Any reason?? ...

How should I keep track of open DataReaders?

I've been tasked to create a class that clients can use to get data from a specific data source. For example, the main routines will be IDataReader GetDataReader(DbCommand command); DataSet GetDataSet(DbCommand command); I know that the Data Access Application block does this but I can't use the application block for reasons I won't...

Manipulate DATA FILE (text) stored as varbinary(max) in sql table

Hi, looking for help and need pointing in the right direction, can anyone assist? Have a data file (txt) that contains 10000 numbers/data points. Storing the data file as varbinary(MAX) in an SQL table. My goal is to retrieve the file on user request and plot/chart the numbers as a line chart. No problem in getting DataReader to displ...

Linq to Sql vs Nhibernate vs SubSonic vs Stored Procedure (Help)

Hello, I am looking to develop a website for a news channel. So, Obviously its gonna receive a lot of hits daily and will be updated a lot on daily basis.. I have experience in ASP.Net and SQL Server.. These are the technologies i am considering to work with. Please help me choose the right method considering the amount of load it w...

Datareader or Dataset in Winform with long trips to database?

I've got a Winform app that will be used in the US and China. The SQL Server 2005 database is in the US, so the data access is going to be slower for the people in China. I'm deciding between using a DataReader and a Dataset for best performance. The data will immediately be loaded into business objects upon retrieval. Question: Which p...