public SqlDataSource(DatasourceConfiguration configurationToTest = null)
{
if (configurationToTest != null)
{
SetupConnection(configurationToTest);
if (Connection != null)
{
CloseConnection();
}
}
}
public static void SaveToLocal(DatasourceConfiguration conf)
{
try
{
FileStream fs = new FileStream(@".\DatasourceConfiguration.conf", FileMode.Create);
BinaryFormatter bin = new BinaryFormatter();
bin.Serialize(fs, conf);
fs.Close();
}
catch (Exception ex)
{
}
}
public override void SetupConnection(DatasourceConfiguration config)
{
try
{
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
sb.DataSource = config.Datasource;
sb.UserID = config.UserId;
sb.Password = config.Password;
sb.InitialCatalog = config.InitialCatalog;
SqlConnection conn = new SqlConnection(sb.ConnectionString);
conn.Open();
Connection = conn;
}
catch (Exception ex)
{
throw;
}
}
public static DatasourceConfiguration ReadFromLocal()
{
FileStream fs = null;
try
{
fs = new FileStream(@".\DatasourceConfiguration.conf", FileMode.Open);
BinaryFormatter bin = new BinaryFormatter();
DatasourceConfiguration conf = (DatasourceConfiguration)bin.Deserialize(fs);
fs.Close();
return(conf);
}
catch (Exception ex)
{
if (fs != null)
{
fs.Close();
}
return(new DatasourceConfiguration());
}
}
public override void SetupConnection(DatasourceConfiguration config)
{
try
{
FbConnectionStringBuilder sb = new FbConnectionStringBuilder();
sb.DataSource = config.Datasource;
if (config.Port > 0)
{
sb.Port = config.Port;
}
sb.Database = config.InitialCatalog;
sb.UserID = config.UserId;
sb.Password = config.Password;
FbConnection conn = new FbConnection(sb.ConnectionString);
conn.Open();
Connection = conn;
}
catch (Exception ex)
{
throw;
}
}
public abstract void SetupConnection(DatasourceConfiguration config);