Database

armax75 wrote:

I want to use a dataset that can work with different database

armax75 wrote:

My application must be database indipendent.

DataSet ds = new DataSet();
// ... Call stored proc
Console.WriteLine("Table 1 Rows: " + ds.Tables[0].Rows.Count().ToString();
Console.WriteLine("Table 2 Rows: " + ds.Tables[1].Rows.Count().ToString();
Console.WriteLine("Table 3 Rows: " + ds.Tab;es[2].Rows.Count().ToString();

armax75 wrote:

My question is, "Is it possible to switch into a differrent back-end such as SQL to access without changing any SQL commands ? "

public abstract class DataAccessObject
{
    public abstract DataSet RunSomeQuery(string param1, int param2);
}
 
public class DataAccessObjectSqlServer : DataAccessObject
{
    public override DataSet RunSomeQuery(string param1, int param2)
    {
        // SQL Server specific code here
    }
}
 
public class DataAccessObjectMSAccess : DataAccessObject
{
    public override DataSet RunSomeQuery(string param1, int param2)
    {
        // Microsoft Access specific code here
    }
}

armax75 wrote:

built by dataset wizard

armax75 wrote:

what I want to do is to find a way to switch to SQL server at runtime using the same dataset

armax75 wrote:

Changing the connection string the dataset's query don't function

armax75 wrote:

I've used standard sql

armax75 wrote:

There's a way to use an xml file that can change the query in dataset (according to the rigth database)set designer at compile time.