Database

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.

SELECT
    AutoNumber,
    MarkOne.Price
FROM
    MarkOne
INNER JOIN
    (SELECT 
        DestinationAirport,
        DepartureAirport,
        AirLineCode,
        FareClass,
        MIN(Price) AS Price
     FROM 
        dbo.MarkOne 
     GROUP BY 
        DestinationAirport,
        DepartureAirport,
        AirLineCode,
        FareClass) gMark
     ON(gMark.DestinationAirport = MarkOne.DestinationAirport AND
        gMark.DepartureAirport = MarkOne.DepartureAirport AND
        gMark.AirLineCode = MarkOne.AirLineCode AND
        gMark.FareClass = MarkOne.FareClass AND	
        gMark.Price = MarkOne.Price)

Deepasubramanian wrote:

1.In what scenarios we prefer to use UDFs instead of Stored Procedures?
2.UDFs won't allow out paramaters like Stored Procedures.Other than that how really an UDF differ from Stored Procedure.

SELECT a, b, dbo.MyUDF(c, d) FROM MyTable