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.
13
questions
0
votes
2
answers
1k
views
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 ...
0
votes
3
answers
2k
views
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 ...
- 105
1
vote
3
answers
1k
views
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 ...
user251748
2
votes
1
answer
99
views
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 ...
- 23
4
votes
1
answer
262
views
.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 ...
- 149
0
votes
2
answers
2k
views
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 ...
1
vote
2
answers
2k
views
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 ...
2
votes
4
answers
1k
views
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 ...
- 200
3
votes
2
answers
17k
views
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 ...
- 538
4
votes
3
answers
1k
views
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 ...
- 3,305
6
votes
5
answers
9k
views
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 ...
- 357
184
votes
3
answers
103k
views
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 ...
- 1,949
2
votes
2
answers
3k
views
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 ...
- 1,842