public void Connect()
{
try
{
if (AdoCon.State == ConnectionState.Open)
{
Close();
}
AdoCon.ConnectionString = "Server=" + Server.Replace(".local", "") + ";Initial Catalog=" + DataBase + ";User Id=" + User + ";Password="******";MultipleActiveResultSets=True;";
AdoCon.Open();
if (context_info != null)
{
SqlCommand cmd = AdoCon.CreateCommand();
string lSql = "set CONTEXT_INFO @C";
cmd.CommandText = lSql;
SqlParameter param = new SqlParameter();
param.ParameterName = "@C";
param.DbType = DbType.Binary;
param.Size = 127;
param.Value = context_info;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
}
}
catch
{
throw;
}
}
private bool disposedValue = false; // To detect redundant calls
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
AdoCon.Close();
AdoCon.Dispose();
IP = null;
oServer = null;
}
// TODO: free unmanaged resources (unmanaged objects) and override a finalizer below.
// TODO: set large fields to null.
disposedValue = true;
}
}
public async override Task ConnectAsync()
{
try
{
if (AdoCon.State == ConnectionState.Open)
{
Close();
}
string newConnectionString = "";
if (User != "SSPI")
{
newConnectionString = "Server=" + Server.Replace(".local", "") + ";Initial Catalog=" + DataBase + ";User Id=" + User + ";Password="******";MultipleActiveResultSets=True;Connection Lifetime=3;Max Pool Size=3";
}
else
{
newConnectionString = "Server=" + Server.Replace(".local", "") + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI;MultipleActiveResultSets=True;Connection Lifetime=3;Max Pool Size=3";
}
if (newConnectionString != AdoCon.ConnectionString)
{
AdoCon.ConnectionString = newConnectionString;
}
await AdoCon.OpenAsync();
if (context_info != null)
{
SqlCommand cmd = AdoCon.CreateCommand();
string lSql = "set CONTEXT_INFO @C";
cmd.CommandText = lSql;
SqlParameter param = new SqlParameter();
param.ParameterName = "@C";
param.DbType = DbType.Binary;
param.Size = 127;
param.Value = context_info;
cmd.Parameters.Add(param);
await cmd.ExecuteNonQueryAsync();
}
}
catch
{
throw;
}
}
public override void Connect()
{
try
{
if (AdoCon.State == ConnectionState.Open)
{
Close();
}
string newConnectionString = "";
if (User != "SSPI")
{
newConnectionString = string.Format("Server={0};Initial Catalog={1};User Id={2};Password={3};MultipleActiveResultSets=True;Connection Lifetime=3;Max Pool Size=3", Server, DataBase, User, Password);
}
else
{
newConnectionString = string.Format("Server={0};Initial Catalog={1};Integrated Security=SSPI;MultipleActiveResultSets=True;Connection Lifetime=3;Max Pool Size=3", Server, DataBase);
}
if (newConnectionString != AdoCon.ConnectionString)
{
AdoCon.ConnectionString = newConnectionString;
}
AdoCon.Open();
if (context_info != null)
{
SqlCommand cmd = AdoCon.CreateCommand();
string lSql = "set CONTEXT_INFO @C";
cmd.CommandText = lSql;
SqlParameter param = new SqlParameter();
param.ParameterName = "@C";
param.DbType = DbType.Binary;
param.Size = 128;
param.Value = context_info;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Close()
{
AdoCon.Close();
}
public override void Close()
{
AdoCon.Close();
}
