public async Task <object> GetDataAsync()
{
object results = null;
var connBuilder = new FluentDbConnectionBuilder2(_options.ConnectionString)
.UseTransaction(IsolationLevel.ReadUncommitted)
.AddCommand("INSERT INTO dbo.[SomeTable] (Col1, Col2) SELECT '@Col1Data', '@Col2Data';",
CommandType.Text,
options =>
{
options.Parameters.AddWithValue("@Col1Data", SqlDbType.VarChar, "Test");
options.Parameters.AddWithValue("@Col2Data", SqlDbType.VarChar, "Test2");
options.Assert(results => results.RecordsAffected == 1);
})
.AddCommand("AddMoreStuff", CommandType.StoredProcedure, options =>
{
options.Parameters.AddWithValue("@Param1", SqlDbType.VarChar, "Test");
options.Parameters.AddWithValue("@Param2", SqlDbType.VarChar, "Test2");
options.ReadWith(reader =>
{
results = reader[0];
});
});
await connBuilder.ExecuteAsync();
return(results);
}
public static async Task Main(string[] args)
{
var connBuilder = new FluentDbConnectionBuilder2(args[0])
.AddCommand("SELECT * FROM dbo.[Schedule] WHERE Id = @Id",
CommandType.Text,
(o) =>
{
o.Parameters.AddWithValue("@Id", SqlDbType.Int, 1);
o.ReadWith(async reader =>
{
while (await reader.ReadAsync())
{
var row = "";
for (int i = 0; i < reader.FieldCount; i++)
{
row += reader[i].ToString();
}
Console.WriteLine(row);
}
});
});
await connBuilder.ExecuteAsync();
}
