public void ExecutePaginated(string connectionString, SqlParserResult parserResult, bool canDisplayRowNumber)
{
if (!canDisplayRowNumber)
{
Execute(connectionString, parserResult);
return;
}
using (var context = new EfContext(connectionString))
{
var result = context.EmployeePaginatedSet
.AsNoTracking()
.FromSql(
parserResult.ParsedSql,
parserResult.DbDataParameters.Cast <object>().ToArray())
.ToList();
Console.WriteLine("SerialNumber\tFirstName\tMiddleName\tLastName\tBirthDate");
foreach (var employee in result)
{
Console.WriteLine(
$"{employee.SerialNumber}\t{employee.FirstName}\t{employee.MiddleName}\t{employee.LastName}\t{employee.BirthDate}");
}
Console.WriteLine();
}
}
public void ExecuteCount(string connectionString, SqlParserResult parserResult)
{
using (var context = new EfContext(connectionString))
{
var count = context.ExecuteScalar <int>(parserResult.ParsedSql, parserResult.DbDataParameters.ToArray());
Console.WriteLine($"TotalCount:{count}");
}
}
public void ExecuteCount(string connectionString, SqlParserResult parserResult)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var count = connection.ExecuteScalar <int>(parserResult.ParsedSql,
parserResult.DbDataParameters.ToDynamicParameters());
Console.WriteLine($"TotalCount:{count}");
}
}
internal SqlParserResult Build()
{
var context = new Context(_config);
_node.Accept(this, context);
var result = new SqlParserResult();
result.ParsedSql = context.GetRawSql().Trim();
result.DebugSql = context.GetFormattedSql().Trim();
result.DbDataParameters = context.SqlParameters.Values.ToList();
return(result);
}
public void Execute(string connectionString, SqlParserResult parserResult)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var result = connection.Query <Employee>(parserResult.ParsedSql,
parserResult.DbDataParameters.ToDynamicParameters());
Console.WriteLine("FirstName\tMiddleName\tLastName\tBirthDate");
foreach (var employee in result)
{
Console.WriteLine(
$"{employee.FirstName}\t{employee.MiddleName}\t{employee.LastName}\t{employee.BirthDate}");
}
Console.WriteLine();
}
}
public void Execute(string connectionString, SqlParserResult parserResult)
{
using (var context = new EfContext(connectionString))
{
var result = context.Employees
.AsNoTracking()
.FromSql(
parserResult.ParsedSql,
parserResult.DbDataParameters.Cast <object>().ToArray())
.ToList();
Console.WriteLine("FirstName\tMiddleName\tLastName\tBirthDate");
foreach (var employee in result)
{
Console.WriteLine(
$"{employee.FirstName}\t{employee.MiddleName}\t{employee.LastName}\t{employee.BirthDate}");
}
Console.WriteLine();
}
}
public void ExecutePaginated(string connectionString, SqlParserResult parserResult, bool canDisplayRowNumber)
{
if (!canDisplayRowNumber)
{
Execute(connectionString, parserResult);
return;
}
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
var result = connection.Query <EmployeePaginated>(parserResult.ParsedSql,
parserResult.DbDataParameters.ToDynamicParameters());
Console.WriteLine("SerialNumber\tFirstName\tMiddleName\tLastName\tBirthDate");
foreach (var employee in result)
{
Console.WriteLine(
$"{employee.SerialNumber}\t{employee.FirstName}\t{employee.MiddleName}\t{employee.LastName}\t{employee.BirthDate}");
}
Console.WriteLine();
}
}
