Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [ado.net]

ADO.Net is a part of the Microsoft.NET base class library. It allows programmers to access and modify data stored in relational database systems. It can also be used to access data from non-relational sources.

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).

13 questions
184
votes
3 answers

Is Entity Framework Suitable For High-Traffic Websites?

Is Entity Framework 4 a good solution for a public website with potentially 1000 hits/second? In my understanding EF is a viable solution for mostly smaller or intranet websites, but wouldn't scale easily for something like a popular community…
niaher
  • 1,949
  • 3
  • 12
  • 7
6
votes
5 answers

How might a Windows 8 Metro app handle back end database access?

While researching Metro and WinRT I haven't been able to find anything regarding enterprise apps and database access. All I hear about is the front end development. Does anyone have any idea of how a Metro app will access a database server? Will…
Ein Doofus
  • 357
  • 1
  • 5
  • 11
4
votes
1 answer

.NET DataSource binding for legacy SQL Server DB with undefined relationships

I'm designing a utility that will load data into a legacy SQL Server Database. I've been trying to mock up a simple WinForms utility with C# using the DataSource connectors (Tried a straight ORM Entity Framework approach first, but was having…
wesmantooth
  • 149
  • 5
4
votes
3 answers

Proper & Efficient Structure for an entity layer?

Context Web application based on the .NET Framework written in C# and following the MVC design pattern. Question What is the most efficient way to structure an entity layer consisting on various data inputs? Background I am developing an application…
Matt Cashatt
  • 3,315
  • 5
  • 24
  • 35
3
votes
2 answers

Static DataTable or DataSet in a class - bad idea?

I have several instances of a class. Each instance stores data in a common database. So, I thought "I'll make the DataTable table field static, that way every instance can just add/modify rows to its own table field, but all the data will actually…
Superbest
  • 538
  • 1
  • 3
  • 12
2
votes
2 answers

Best practice to save data in different databases using C# ADO.NET

I would like to know if you guys have any best practice when dealing with transaction between different databases vendors. For example, if you have a C# application that save customer data in two databases (one Oracle and the other Microsoft), what…
Junior Mayhé
  • 1,842
  • 2
  • 17
  • 35
2
votes
1 answer

ADO.NET - Is it better to handle a combo box or label event, and where should the data be sourced from?

Context I recently wrote a final exam that required using a BindingSource object with ADO.NET to populate a number of combo box and label controls from which the user could perform basic business functions. I got it working but had some reservations…
Skannen
  • 23
  • 4
2
votes
4 answers

ado.net or EF for a point-of-sale system

We have a point-of-sale system that was developed using ado.net, our current concern is to make the application real fast in creating transactions (sales). Usually there are no performance concerns with high end PCs but with with low end PCs, the…
whastupduck
  • 200
  • 1
  • 11
1
vote
3 answers

Why is a duplicate database Insert fault not considered a Concurrency Error?

A textbook I am teaching from about ASP.Net using ADO.Net in C# says: Note that concurrency checking isn't necessary here, because a concurrency error can't occur for an insert operation. The textbook emphasizes using Optimistic Concurrency (as…
user251748
1
vote
2 answers

What is right choice of Data Access Layer for large application

I am using Singleton pattern for my application, I have used ADO.NET Entity framework as my Data Access Layer, after login to my application, it's taking 3 to 5 minutes to load the dashboard. Is there a way to reduce the time? Or I have to look for…
Mohammed Bilal
  • 55
  • 1
  • 4
0
votes
3 answers

Keeping objects in RAM vs more queries to the database

So this is my DataStructure: Project - Name - ID - Image - History - User - Comment When my application first starts it is pulling all projects with all details. obviously very slow -high RAM (mostly because of images) For…
Felix D.
  • 105
  • 4
0
votes
2 answers

How to connect mvc application using entityframework or ado.net?

I am an ASP.NET developer. I want to learn ASP.NET MVC. In fact I am learning it. But Now I am confused at a point. How can I connect my database to my application. Using entity framework or linq or ado.net. I have good knowledge about ado.net. But…
Azad Chouhan
  • 1
  • 2
-1
votes
2 answers

How to initialize base class property once instead of passing it from all derived classes?

I have a small library where I am performing 1 long running operation and based on that operation,I am saving some data inside database tables.Now this is small library which does not include alot of database tables operation hence I have used…
I Love Stackoverflow
  • 93
  • 9