public async Task Test4()
{
var dbContext = Setup.ServiceProvider.GetService <SqliteConnection>();
var time = DateTimeOffset.UtcNow;
var blogPost = new BlogPostDto
{
Title = "SqLite",
DeprecatedDate = time
};
var(sql, parameters) = blogPost.CreateInsertSqlStatement(ConnectionType.SqLite);
await dbContext.ExecuteAsync(sql, parameters).ConfigureAwait(false);
var results = await dbContext.QueryAsync <BlogPostDto>("select Id, Title, DeprecatedDate from blog_Posts").ConfigureAwait(false);
var comment = new CommentDto
{
BlogPostId = 2,
Comment = "Hello world!"
};
(sql, parameters) = comment.CreateInsertSqlStatement(ConnectionType.SqLite);
await dbContext.ExecuteAsync(sql, parameters).ConfigureAwait(false);
Assert.AreEqual(1, results.First().Id);
Assert.AreEqual("SqLite", results.First().Title);
Assert.AreEqual(time, results.First().DeprecatedDate);
}
