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); }