public async Task Create_Success() { var repository = new Core.Repositories.Sql.PostRepository(ConnectionString); var post = new Post { Title = "Test title", UserId = "1", Content = "Test content.", CreationDateTime = DateTime.UtcNow, RevisionDateTime = DateTime.UtcNow }; await repository.CreateAsync(post); Assert.NotNull(post.Id); using(var connection = new SqlConnection(ConnectionString)) { var testPost = (await connection.QueryAsync<Post>($"SELECT * FROM [Post] WHERE [Id] = '{post.Id}';")).FirstOrDefault(); Assert.NotNull(testPost); Assert.Equal(post.Id, testPost.Id); } }
public async Task Create_Success() { var repository = new Core.Repositories.Sql.PostRepository(ConnectionString); var post = new Post { Title = "Test title", UserId = "1", Content = "Test content.", CreationDateTime = DateTime.UtcNow, RevisionDateTime = DateTime.UtcNow }; await repository.CreateAsync(post); Assert.NotNull(post.Id); using (var connection = new SqlConnection(ConnectionString)) { var testPost = (await connection.QueryAsync <Post>($"SELECT * FROM [Post] WHERE [Id] = '{post.Id}';")).FirstOrDefault(); Assert.NotNull(testPost); Assert.Equal(post.Id, testPost.Id); } }