public async Task It_can_scaffold_a_DbContext_in_a_CSharpKernel()
{
var connectionString = MsSqlFact.GetConnectionStringForTests();
using var kernel = await CreateKernel();
var result = await kernel.SubmitCodeAsync(
$"#!connect --kernel-name adventureworks mssql \"{connectionString}\" --create-dbcontext");
var events = result.KernelEvents.ToSubscribedList();
events.Should().NotContainErrors();
result = await kernel.SubmitCodeAsync("adventureworks.AddressType.Count()");
events = result.KernelEvents.ToSubscribedList();
events.Should().NotContainErrors();
events.Should()
.ContainSingle <ReturnValueProduced>()
.Which
.Value
.As <int>()
.Should()
.Be(6);
}
public async Task It_can_connect_and_query_data()
{
var connectionString = MsSqlFact.GetConnectionStringForTests();
using var kernel = await CreateKernel();
var result = await kernel.SubmitCodeAsync(
$"#!connect --kernel-name adventureworks mssql \"{connectionString}\"");
result.KernelEvents
.ToSubscribedList()
.Should()
.NotContainErrors();
result = await kernel.SubmitCodeAsync(@"
#!adventureworks
SELECT TOP 100 * FROM Person.Person
");
var events = result.KernelEvents.ToSubscribedList();
events.Should().NotContainErrors();
events.Should()
.ContainSingle <DisplayedValueProduced>()
.Which
.FormattedValues
.Should()
.ContainSingle(f => f.MimeType == HtmlFormatter.MimeType);
}