public async Task truncate_customers_table_performanse_tests()
{
int result;
using (var session = sessionFactory.OpenAsyncSession())
{
using (var transaction = session.BeginTransaction())
{
var query = new SqlQuery("TRUNCATE TABLE Customers");
result = await session.Advanced.ExecuteAsync(query);
transaction.Commit();
}
}
result.Should().Be(-1);
}
public async Task ML_FetchSingle()
{
using (var session = sessionFactory.OpenAsyncSession())
{
using (var transaction = session.BeginTransaction())
{
var result = await session.SingleAsync <Customer>(new Guid("0ec1fd41-8acf-4cab-aeff-021f29209c97"));
transaction.Commit();
}
}
}
public async Task ML_Pagination()
{
using (var session = sessionFactory.OpenAsyncSession())
{
using (var transaction = session.BeginTransaction())
{
var query = new SqlQuery("SELECT * FROM [Customers]");
var result = await session.PagedAsync <Customer>(query, PagingOptions.ForPage(1, 100));
transaction.Commit();
}
}
}
public async Task ML_InsertData()
{
var customer = fixture.Create <Customer>();
using (var session = sessionFactory.OpenAsyncSession())
{
using (var transaction = session.BeginTransaction())
{
await session.InsertAsync(customer);
transaction.Commit();
}
}
}
public async Task ML_UpdateData()
{
using (var session = sessionFactory.OpenAsyncSession())
{
using (var transaction = session.BeginTransaction())
{
var customer = await session.SingleAsync <Customer>(new Guid("0ec1fd41-8acf-4cab-aeff-021f29209c97"));
customer.Name = "Randomich12";
customer.Phone = "1234567890";
customer.Age = 25;
customer.Status = CustomerStatus.Closed;
var updated = await session.UpdateAsync(customer);
transaction.Commit();
}
}
}
