Questions tagged [provider-independent]
4 questions
2
votes
2 answers
.net : Are DataSet and TableAdapters agnostic of database and vendor?
We need the application we are building to be Database-agnostic. In particular, I need it to be able work with SQL Server, Oracle and MySQL. In the future, possibly other DB Vendors will be added to the list. Of course, whatever DB is to be used…
Markos Fragkakis
- 7,499
- 18
- 65
- 103
1
vote
1 answer
How can I use same EF entities for SQL Server Compact and SQL Server?
I have a project to create a program that can operate in two modes:
internal users access a centralized database (SQL Server) and can view/edit each others items, or
external customers create all their own data locally (SQL Server Compact) and…
N Jones
- 1,004
- 11
- 18
1
vote
6 answers
How to design a provider-independent DAL
I am currently developing a query builder application, basically, a simple graphical interface that should allow users with no knowledge of SQL to define various queries on a database (joins, SELECT, INSERT, UPDATE, DELETE). I will be using .NET…
kjv
- 11,047
- 34
- 101
- 140
1
vote
2 answers
Entity Framework : Is there any smart way to implement data access so that I can switch web.config settings to switch provider
I want to implement Data Access Layer in Entity Framework in a way that one can switch from excel to sqlite or ms access of ms sql server using a single setting in web.config.
Is there any good suggestion or example for this available?
Prashant Lakhlani
- 5,758
- 5
- 25
- 39