public async Task SelectPagedAsync() { using (var connection = await GetOpenConnection()) { var app = new MyApplication { Name = Guid.NewGuid().ToString(), CreateTime = DateTime.Now }; await connection.InsertAsync(app); var query = new MyApplicationQuery() { Take = 10, Skip = 0, NamePattern = app.Name }; var applications = await connection.SelectAsync(query); Assert.NotEmpty(applications); Assert.Equal(1, query.Count); query = new MyApplicationQuery() { Take = 10, Skip = 0, NamePattern = "111111111111111111111111111111111111111111111" }; applications = await connection.SelectAsync(query); Assert.Empty(applications); Assert.Equal(0, query.Count); applications = await connection.SelectAsync(new MyApplicationQuery() { Take = 10, Skip = 0, Name = app.Name }); Assert.NotEmpty(applications); } }
public async Task UpdateAsync() { using (var connection = await GetOpenConnection()) { var app = new MyApplication { Name = Guid.NewGuid().ToString(), CreateTime = DateTime.Now }; await connection.InsertAsync(app); var application = await connection.SelectFirstOrDefaultAsync(new MyApplicationQuery() { Ids = new[] { app.Id } }); if (application != null) { application.Name = Guid.NewGuid().ToString(); await connection.UpdateAsync(application); } } }