I´m want to implement sybase provider factory support to some applications. Currently I have AseDatabase(sysbase system 12).
the current sql provider factory work fine.
but i don't know some guideline to star point.
I try adding a reference to Sybase.Data.AseClient into my application, set the Connection string in app.config
but don't run the samples(retrieve records with a storeprocedure).
How I can solved this issue? Any idea or suggestion?
these are my current sql provider factory c# classes code :
//Creates and prepares a new DbCommand object on
//a new connection
public static DbCommand CreateCommand()
//Obtain the database provider name
string dataProviderName = WebStoreXConfiguration.DbProviderName;
//Obtain the database connection string
string connectionString = WebStoreXConfiguration.DbConnecctionString;
//Create a new data provider factory
DbProviderFactory factory = DbProviderFactories.GetFactory(dataProviderName);
//Obtain a database specific connecction object
DbConnection conn = factory.CreateConnection();
//Set the connection string
conn.ConnectionString = connectionString;
//Create a database specific command object
DbCommand comm = conn.CreateCommand();
//Set the command type to stored procedure
comm.CommandType = CommandType.StoredProcedure;
//Return the initialized command object
thanks for your help,.
Please see this related post:
Global Technology and Solutions