Stack Overflow
Stack Overflow

Questions tagged [ado.net]

ADO.Net is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational sources. It is a part of the base class library that is included with the Microsoft .NET Framework.

ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework.

It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but it was changed so extensively that it can be considered an entirely new product.

In modern practice, ADO.NET is often implemented along side the query language LINQ, and the Entity Framework (Microsoft's OR/M persistence layer).

10075 questions
3
votes
2 answers

C#, OLEDB reading a Excel file from a specified row

I need to read a table in an Excel file starting from 10th row (rows before 10th row are having other data and they are not in a correct format and coteins banners, cell splits, ect) using Ado.Net. How can I do that?
Thanushka
  • 1,395
  • 5
  • 25
  • 54
3
votes
4 answers

How to deal with datatypes returned by LINQ

I'm new to LINQ, I've used LINQ to SQL to link to two tables, it does return data, which is cool. What I'm trying to understand is what datatype is being returned and how do I work with this datatype? I'm used to dealing with datatables. Are we…
alchemical
  • 13,559
  • 23
  • 83
  • 110
3
votes
6 answers

"MySqlException: Table 'mysql.proc' doesn't exist" when executing MySQL stored procedures in .NET Core

I am using the ADO.NET data provider MySql.Data.MySqlClient to access a MySQL database from .NET Core and most things work, but whenever I try to access a stored procedure I see the following exception message: MySql.Data.MySqlClient.MySqlException…
MikeBeaton
  • 3,314
  • 4
  • 36
  • 45
3
votes
1 answer

automapper example for ado.net to viewmodel mapping

i have not used automapper before, is there a link with a sample of how to map dataset rows to a asp.net mvc 2 viewmodel ?
user603007
  • 11,416
  • 39
  • 104
  • 168
3
votes
1 answer

How can I get Entity Framework 1.0 to use the nolock hint when accessing a specific entity

I would like to access an entity (called Document) which is mapped to a table (called Document) using Entity Framework 1.0 but it is very important that this table is not locked when the data is read. There are articles both online, and on…
Swaff
  • 13,548
  • 4
  • 26
  • 26
3
votes
2 answers

Oracle Managed DataAccess connection object is keeping the connection open

I'm using Oracle.ManagedDataAccess Nuget package version 18.3.0. I tried many things. I tried to dispose everything I can think of, even oracle parameters objects. And wrapped everything inside a using block but to no avail. The only thing that…
Rickless
  • 1,377
  • 3
  • 17
  • 36
3
votes
3 answers

SQL query on ADO.net limitation with 2100+ parameters

I am trying to implement an ADO.NET code which executes the SQL query with multiple parameters. Looks like SQL parameter limit is 2100 and does not accept more than this limit. How do I achieve with my below code to have this accept more than the…
Dhillli4u
  • 117
  • 12
3
votes
1 answer

Why Doesn't The EntityConnection Object Contain the Login Password?

I've got an app that uses EF CTP5. In this particular situation, i need to degrade to some classic ADO.NET (in order to read multiple result sets in a stored procedure, which EF does not support). As such, im trying to use the existing connection…
RPM1984
  • 72,246
  • 58
  • 225
  • 350
3
votes
1 answer

ADO.net data table is changing time

I have a strange problem with ado.net data table. I have table named Test in database. It has following data . I used a data table to fetch this data. Following is my code: using (SqlConnection cnn = new SqlConnection(strConString)) …
Manpreet Singh Dhillon
  • 833
  • 11
  • 17
3
votes
4 answers

Architectural design for multi customer project with sligthly different database structure (for each customer)

I'm maintaining an application that was copy-pasted for each new customer (...yeah, I know). If a new customer wanted some new functions which the others didn't need, only his code part was changed. The Solution also includes a sort of "common.dll"…
Patric
  • 2,789
  • 9
  • 33
  • 60
3
votes
1 answer

Pervasive SQL ADO.NET data provider

I have an asp.net, c# application using MSSQL 2008 server. At some point, i also want to insert some data into a pervasive v10 database. Was looking for the pervasive data provider…
rhys
  • 35
  • 2
  • 4
3
votes
2 answers

Alternate/candidate key in ADO.NET data model

I need to have an entity that has two separate candidate keys where one of them is the primary key, which is a surrogate identity key, and another one that is an alternate key representing the real unique attribute. I need to have them both…
amirmonshi
  • 649
  • 5
  • 19
3
votes
1 answer

How to get SQLite up and running in Visual Studio?

I'm having major issues trying to connect an existing SQLite database to my C# application. I've installed SQLite bundle for 32 and 64 bit, I've installed SQLite/SQL Server Compact Tools extension, installed SQLite dlls into GAC, added various…
DanDan
  • 1,038
  • 4
  • 15
  • 28
3
votes
1 answer

Finding common columns from two datatable and using those for Join condition in LINQ

I have two Data Tables and these are completely dynamic. These would be generated at runtime. Now I want to Join these tables by finding the common columns. Kindly check below code for further information public DataTable DataTableJoiner(DataTable…
suryakiran
  • 1,976
  • 25
  • 41
3
votes
2 answers

How To Add Row,Column and Merge row at the Runtime on GridView According to Data Property Provided On Sqldatareader?

I am working on ASP.NET3.5. I have to present mention Dataset on GridView under the given format at the run time. Datset EMP_ID EMP_NAME 2011-01-01_FLAG 2011-01-01_INDATE 2011-01-01_INTIME 2011-01-01_INSTATUS 2011-01-01_OUTDATE …
netraThapa
  • 379
  • 2
  • 3
  • 8
1 2 3
…
99
100