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