//public void Select(string name, long adress)
//{
// var quary = new Query();
// // quary.Select().Columns(COLUMNS_MAIN).From(FROM_A).Join(JOIN_ADRESS).W;
// //if (name != null)
// // quary.Columns(COLUMNS_MAIN);
// var s = quary.Build();
//}
public void Run()
{
// var list =
var branchnr = 4;
List <Company> list;
using (var conn = new SqlChannel(_con))
{
var qr = new Query(SELECT_ALL_COMPANIES)
.AddParam("@BranchNr", SqlDbType.Int, branchnr);
list = conn.GetRecords <Company>(qr);
}
//var con = new SqlConnection(_con);
//var comnd = new SqlCommand(SELECT_ALL_COMPANIES, con);
//comnd.pa
//con.Open();
//var reader = comnd.ExecuteReader();
//var listobj = Mapper.FromReader<Company>(reader);
//con.Close();
//using (var con = new SqlChannel(_con))
//{
//}
}
public SqlConsumer(SqlChannel channel, IContext context)
: base(channel, context, new NullTransport())
{
m_sql_channel = channel;
}
