csharp
using Enklib.SqlHelper;
SqlHelper.SetProfilerEnabled(true);
string query = "SELECT * FROM Customers";
using (SqlDataReader reader = SqlHelper.ExecuteReader(query))
{
while (reader.Read())
{
}
}
Console.WriteLine(SqlHelper.GetProfilerReport());
csharp
using Enklib.SqlHelper;
SqlHelper.SetCacheEnabled(true);
string query = "SELECT * FROM Customers";
using (SqlDataReader reader = SqlHelper.ExecuteReader(query))
{
while (reader.Read())
{
}
}
string preparedQuery = "SELECT * FROM Orders WHERE CustomerId = @customerId";
using (SqlDataReader reader = SqlHelper.ExecuteReader(preparedQuery, new SqlParameter("@customerId", customerId)))
{
while (reader.Read())
{
}
}
csharp
using Enklib.SqlHelper;
SqlHelper.SetConnectionPoolSize(100);
SqlHelper.SetMaxCacheItems(100);
SqlHelper.SetCommandTimeout(TimeSpan.FromSeconds(30));
