public async void Read_DispoableAsync()
{
IDbJob <IEnumerable <Currency> > job = _dbConnector.Read <Currency>("SELECT TOP(3) * FROM [Sales].[Currency]");
using (IDbDisposable <IEnumerable <Currency> > result = await job.ExecuteDisposableAsync())
{
Assert.Equal(3, result.Source.Count());
var values = (result.Source as List <Currency>);
Assert.Equal("AED", values[0].CurrencyCode);
Assert.Equal("AFA", values[1].CurrencyCode);
Assert.Equal("ALL", values[2].CurrencyCode);
}
}
public void Read_DispoableHandled()
{
IDbJob <IEnumerable <Currency> > job = _dbConnector.Read <Currency>((cmd) =>
{
cmd.CommandText = "SELECT TOP(3) * FROM [Sales].[Currency]";
});
using (IDbDisposable <IEnumerable <Currency> > result = job.ExecuteDisposableHandled().Data)
{
Assert.Equal(3, result.Source.Count());
var values = (result.Source as List <Currency>);
Assert.Equal("AED", values[0].CurrencyCode);
Assert.Equal("AFA", values[1].CurrencyCode);
Assert.Equal("ALL", values[2].CurrencyCode);
}
}
