} // End Sub ExecuteReader
public void ExecuteReader(string sql, System.Data.CommandBehavior behaviour, DataReaderCallback_t readCallback)
{
using (System.Data.Common.DbCommand cmd = this.CreateCommand(sql))
{
this.ExecuteReader(cmd, behaviour, readCallback);
}
}
public void ExecuteReader(string sql, DataReaderCallback_t readCallback)
{
using (System.Data.Common.DbCommand cmd = this.CreateCommand(sql))
{
this.ExecuteReader(cmd, readCallback);
}
} // End Sub ExecuteReader
public virtual void ExecuteReader(string sql, DataReaderCallback_t callback)
{
using (System.Data.Common.DbCommand cmd = CreateCommand(sql))
{
ExecuteReader(cmd, callback);
} // End Using cmd
}
public void ExecuteReader(System.Data.Common.DbCommand cmd, DataReaderCallback_t readCallback)
{
using (System.Data.Common.DbConnection dbConnection = this.GetConnection())
{
using (System.Data.Common.DbDataReader dataReader = this.ExecuteReader(cmd, dbConnection))
{
readCallback(dataReader);
} // End Using dataReader
this.CloseConnection(dbConnection);
} // End Using dbConnection
}
} // End Sub ProcessRequest
public static void GetTableData(DataReaderCallback_t callback)
{
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.DataSource = @"COR-W10-112\SQLEXPRESS";
csb.InitialCatalog = "COR_Basic_Demo_V4";
csb.IntegratedSecurity = true;
if (!csb.IntegratedSecurity)
{
csb.UserID = "ApertureWebServicesDE";
csb.Password = "******";
} // End if (!csb.IntegratedSecurity)
Loggy.cDAL DAL = Loggy.cDAL.CreateInstance();
DAL.ConnectionString = csb.ConnectionString;
DAL.ExecuteReader("SELECT * FROM T_Benutzer", callback);
}
} // End Function ExecuteScalar(strSQL)
public virtual void ExecuteReader(System.Data.IDbCommand cmd, DataReaderCallback_t callback)
{
using (System.Data.Common.DbConnection con = this.Connection)
{
cmd.Connection = con;
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
using (System.Data.Common.DbDataReader idr = (System.Data.Common.DbDataReader)cmd.ExecuteReader(
System.Data.CommandBehavior.SequentialAccess | System.Data.CommandBehavior.CloseConnection
))
{
callback(idr);
}
if (con.State != System.Data.ConnectionState.Closed)
{
con.Close();
}
} // End Using con
}
// ConnectionLess
public void ExecuteReader(System.Data.Common.DbCommand cmd, System.Data.CommandBehavior behaviour, DataReaderCallback_t readCallback)
{
using (System.Data.Common.DbConnection connect = this.GetConnection())
{
using (System.Data.Common.DbDataReader dataReader = this.ExecuteReader(cmd, behaviour, connect))
{
readCallback(dataReader);
}
this.CloseConnection(connect);
}
} // End Sub ExecuteReader
