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