private static void QueryBuilder()
{
string connectionString = ConfigurationManager.ConnectionStrings["TMS"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connectionString))
{
AQueryBuilder queryBuilder = new AQueryBuilder();
queryBuilder.Id = 1;
queryBuilder.Val = "A1";
queryBuilder.ChoseField("ListC,D,ListB");
string sql = queryBuilder.BuildQuery("Id desc", 1, 50);
//string sql = queryBuilder.BuildScalar( "COUNT", "Id" );
Console.WriteLine(sql);
var resutls = conn.Query(sql, queryBuilder.MakeResult, queryBuilder.Paramters, splitOn: queryBuilder.SplitOn).Where(r => r != null);
int count = 0;
foreach (var r in resutls)
{
count++;
Console.WriteLine("{0}-{1}-{2}", count, r.Id, r.Val);
//Console.WriteLine( "Number B:{0}", r.ListB.Count );
//Console.WriteLine( "Number C:{0}", r.ListC.Count );
//Console.WriteLine( "D Value:{0}", r.D.Val );
Console.WriteLine("----------------------------");
}
}
}
private static void QueryBuilder()
{
string connectionString = ConfigurationManager.ConnectionStrings[ "TMS" ].ConnectionString;
using ( SqlConnection conn = new SqlConnection( connectionString ) )
{
AQueryBuilder queryBuilder = new AQueryBuilder();
queryBuilder.Id = 1;
queryBuilder.Val = "A1";
queryBuilder.ChoseField( "ListC,D,ListB" );
string sql = queryBuilder.BuildQuery( "Id desc", 1, 50 );
//string sql = queryBuilder.BuildScalar( "COUNT", "Id" );
Console.WriteLine( sql );
var resutls = conn.Query( sql, queryBuilder.MakeResult, queryBuilder.Paramters, splitOn: queryBuilder.SplitOn ).Where( r => r != null );
int count = 0;
foreach ( var r in resutls )
{
count++;
Console.WriteLine( "{0}-{1}-{2}", count, r.Id, r.Val );
//Console.WriteLine( "Number B:{0}", r.ListB.Count );
//Console.WriteLine( "Number C:{0}", r.ListC.Count );
//Console.WriteLine( "D Value:{0}", r.D.Val );
Console.WriteLine( "----------------------------" );
}
}
}
