public async Task Can_pass_single_string(bool async, bool cancellation)
{
using var context = new ThudContext();
var commandBuilder = (TestRawSqlCommandBuilder)context.GetService <IRawSqlCommandBuilder>();
if (async)
{
if (cancellation)
{
var cancellationToken = new CancellationToken();
await context.Database.ExecuteSqlRawAsync("<Some query>", new[] { "Branston" }, cancellationToken);
}
else
{
await context.Database.ExecuteSqlRawAsync("<Some query>", "Branston");
}
}
else
{
context.Database.ExecuteSqlRaw("<Some query>", "Branston");
}
Assert.Equal("<Some query>", commandBuilder.Sql);
Assert.Equal(
new List <object> {
"Branston"
}, commandBuilder.Parameters);
}
public async Task Can_pass_array_of_int_params_as_object(bool async, bool cancellation)
{
using var context = new ThudContext();
var commandBuilder = (TestRawSqlCommandBuilder)context.GetService <IRawSqlCommandBuilder>();
if (async)
{
if (cancellation)
{
var cancellationToken = new CancellationToken();
await context.Database.ExecuteSqlRawAsync("<Some query>", new object[] { 1, 2 }, cancellationToken);
}
else
{
await context.Database.ExecuteSqlRawAsync("<Some query>", 1, 2);
}
}
else
{
context.Database.ExecuteSqlRaw("<Some query>", 1, 2);
}
Assert.Equal("<Some query>", commandBuilder.Sql);
Assert.Equal(
new List <object> {
1, 2
}, commandBuilder.Parameters);
}
public async Task Can_pass_no_params(bool async, bool cancellation)
{
using (var context = new ThudContext())
{
var commandBuilder = (TestRawSqlCommandBuilder)context.GetService <IRawSqlCommandBuilder>();
if (async)
{
if (cancellation)
{
var cancellationToken = new CancellationToken();
await context.Database.ExecuteSqlCommandAsync("<Some query>", cancellationToken);
}
else
{
await context.Database.ExecuteSqlCommandAsync("<Some query>");
}
}
else
{
context.Database.ExecuteSqlCommand("<Some query>");
}
Assert.Equal("<Some query>", commandBuilder.Sql);
Assert.Equal(new List <object>(), commandBuilder.Parameters);
}
}
public async Task Can_pass_ints_as_params(bool async)
{
using var context = new ThudContext();
var commandBuilder = (TestRawSqlCommandBuilder)context.GetService <IRawSqlCommandBuilder>();
if (async)
{
await context.Database.ExecuteSqlRawAsync("<Some query>", 1, 2);
}
else
{
context.Database.ExecuteSqlRaw("<Some query>", 1, 2);
}
Assert.Equal("<Some query>", commandBuilder.Sql);
Assert.Equal(
new List <object> {
1, 2
}, commandBuilder.Parameters);
}
