private void ConstructBody()
{
CSBlock usingBlock = new CSBlock("using (SqlCommand sqlCommand = new SqlCommand())");
string sqlString = $"{Quotes}{SqlSelectBuilder.CreateSelectAll(datatable)}{Quotes};";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
usingBlock.Statements.Add($"return ToList(sqlCommand);");
this.Statements.Add(usingBlock.ToString());
}
private void ConstructBody()
{
VBBlock usingBlock = new VBBlock(VBBlockStatement.Using, "Using sqlCommand As New SqlCommand()");
string sqlString = $"{Quotes}{SqlSelectBuilder.CreateSelectAll(datatable)}{Quotes}";
usingBlock.Statements.Add($"sqlCommand.CommandText = {sqlString}");
usingBlock.Statements.Add($"Return ToList(sqlCommand)");
this.Statements.Add(usingBlock.ToString());
}
