public Maybe <bool, Exception[]> BulkInsert(string tableName, DataTable dataTable, string connectionString)
{
var maybe = new Maybe <bool, Exception[]>();
try
{
StructuredQueryLanguage.BulkInsert(tableName, dataTable, connectionString);
maybe = maybe.With(true);
}
catch (Exception ex)
{
maybe.With(new Exception[] { ex });
}
return(maybe);
}
public Maybe <T, Exception[]> ExecuteReader <T>(Func <IDataReader, T> reader, string usp, string connectionString, params SqlParameter[] parameters)
{
var maybe = new Maybe <T, Exception[]>();
try
{
var result = StructuredQueryLanguage.ExecuteReader(reader, usp, connectionString, parameters);
maybe = maybe.With(result);
}
catch (Exception ex)
{
maybe.With(new Exception[] { ex });
}
return(maybe);
}
public Maybe <int, Exception[]> ExecuteNonQuery(string usp, string connectionString, params SqlParameter[] parameters)
{
var maybe = new Maybe <int, Exception[]>();
try
{
var result = StructuredQueryLanguage.ExecuteNonQuery(usp, connectionString, parameters);
maybe = maybe.With(result);
}
catch (Exception ex)
{
maybe.With(new Exception[] { ex });
}
return(maybe);
}
public Response BulkInsert(string tableName, DataTable dataTable, string connectionString)
{
var response = new Response();
try
{
StructuredQueryLanguage.BulkInsert(tableName, dataTable, connectionString);
response = response.AsValid();
}
catch (Exception ex)
{
ex.LogValue($"Error calling {tableName}: {ex}");
}
return(response);
}
public Response <int> ExecuteNonQuery(string usp, string connectionString, params SqlParameter[] parameters)
{
var response = new Response <int>();
try
{
var result = StructuredQueryLanguage.ExecuteNonQuery(usp, connectionString, parameters);
response = response.With(result);
}
catch (Exception ex)
{
ex.LogValue($"Error calling {usp}: {ex}");
}
return(response);
}
public Response <T> ExecuteReader <T>(Func <IDataReader, T> reader, string usp, string connectionString, params SqlParameter[] parameters)
{
var response = new Response <T>();
try
{
var result = StructuredQueryLanguage.ExecuteReader(reader, usp, connectionString, parameters);
response = response.With(result);
}
catch (Exception ex)
{
ex.LogValue($"Error calling {usp} for type {typeof(T).FullName}: {ex}");
}
return(response);
}
public async Task <Maybe <T, Exception[]> > ExecuteReaderAsync <T>(Func <IDataReader, T> reader, string usp, string connectionString, params SqlParameter[] parameters)
{
var maybe = new Maybe <T, Exception[]>();
try
{
var result = await StructuredQueryLanguage.ExecuteReaderAsync(reader, usp, connectionString, parameters);
maybe = maybe.With(result);
}
catch (AggregateException ae)
{
maybe = maybe.With(ae.Flatten().InnerExceptions.ToArray());
}
catch (Exception ex)
{
maybe.With(new Exception[] { ex });
}
return(maybe);
}
public async Task <Maybe <bool, Exception[]> > BulkInsertAsync(string tableName, DataTable dataTable, string connectionString)
{
var maybe = new Maybe <bool, Exception[]>();
try
{
await StructuredQueryLanguage.BulkInsertAsync(tableName, dataTable, connectionString);
maybe = maybe.With(true);
}
catch (AggregateException ae)
{
maybe = maybe.With(ae.Flatten().InnerExceptions.ToArray());
}
catch (Exception ex)
{
maybe.With(new Exception[] { ex });
}
return(maybe);
}
public async Task <Response <T> > ExecuteReaderAsync <T>(Func <IDataReader, T> reader, string usp, string connectionString, params SqlParameter[] parameters)
{
var response = new Response <T>();
try
{
var result = await StructuredQueryLanguage.ExecuteReaderAsync(reader, usp, connectionString, parameters);
response = response.With(result);
}
catch (AggregateException ae)
{
foreach (var e in ae.Flatten().InnerExceptions)
{
e.LogValue($"Aggregate error calling {usp} for type {typeof(T).FullName}: {e}");
}
}
catch (Exception ex)
{
ex.LogValue($"Error calling {usp} for type {typeof(T).FullName}: {ex}");
}
return(response);
}
public async Task <Response> BulkInsertAsync(string tableName, DataTable dataTable, string connectionString)
{
var response = new Response();
try
{
await StructuredQueryLanguage.BulkInsertAsync(tableName, dataTable, connectionString);
response = response.AsValid();
}
catch (AggregateException ae)
{
foreach (var e in ae.Flatten().InnerExceptions)
{
e.LogValue($"Aggregate error calling {tableName}: {e}");
}
}
catch (Exception ex)
{
ex.LogValue($"Error calling {tableName}: {ex}");
}
return(response);
}
public async Task <Response <int> > ExecuteNonQueryAsync(string usp, string connectionString, params SqlParameter[] parameters)
{
var response = new Response <int>();
try
{
var result = await StructuredQueryLanguage.ExecuteNonQueryAsync(usp, connectionString, parameters);
response = response.With(result);
}
catch (AggregateException ae)
{
foreach (var e in ae.Flatten().InnerExceptions)
{
e.LogValue($"Aggregate error calling {usp}: {e}");
}
}
catch (Exception ex)
{
ex.LogValue($"Error calling {usp}: {ex}");
}
return(response);
}
public static Task BulkInsertAsync(string tableName, DataTable dataTable, string connectionString)
{
return(StructuredQueryLanguage.BulkInsertAsync(tableName, dataTable, connectionString));
}
public static Task <int> ExecuteNonQueryAsync(string usp, string connectionString, params SqlParameter[] parameters)
{
return(StructuredQueryLanguage.ExecuteNonQueryAsync(usp, connectionString, parameters));
}
public static Task <T> ExecuteReaderAsync <T>(Func <IDataReader, T> reader, string usp, string connectionString, params SqlParameter[] parameters)
{
return(StructuredQueryLanguage.ExecuteReaderAsync(reader, usp, connectionString, parameters));
}
public static void BulkInsert(string tableName, DataTable dataTable, string connectionString)
{
StructuredQueryLanguage.BulkInsert(tableName, dataTable, connectionString);
}