/// <summary>
/// 封装成DbConnection
/// </summary>
/// <param name="connectionString">连接字符串</param>
/// <param name="providerInvariantName">wappername</param>
/// <returns>wrapperConnectionString</returns>
private static EFTracingConnection CreateTracingConnection(
string connectionString,
string providerInvariantName)
{
string wrapperConnectionString = string.Format(
@"wrappedProvider={0};{1}",
providerInvariantName,
connectionString);
var connection = new EFTracingConnection { ConnectionString = wrapperConnectionString };
return connection;
}
public EFTracingConnection CreateTracingConnection()
{
var tracingConnection = new EFTracingConnection { ConnectionString = tracingConnectionString };
tracingConnection.CommandFinished += (s, e) => {
if(LogToConsole)
Console.WriteLine(e.ToTraceString());
if(!string.IsNullOrEmpty(LogFileName))
File.AppendAllText(LogFileName, e.ToTraceString() + Environment.NewLine + Environment.NewLine);
//try {
// if(LogToConsole)
// Console.WriteLine(e.ToTraceString());
// if(!string.IsNullOrEmpty(LogFileName))
// File.AppendAllText(LogFileName, e.ToTraceString() + Environment.NewLine + Environment.NewLine);
//}
//catch {
// // catch all exceptions so that we don't pass logging-related failures to user code
//}
};
return tracingConnection;
}
private static DbConnection CreateConnection(String connectionString, String providerInvariantName)
{
var wrapperConnectionString = String.Format(@"wrappedProvider={0};{1}", providerInvariantName, connectionString);
var connection = new EFTracingConnection { ConnectionString = wrapperConnectionString };
return (connection);
}
/// <summary>
/// CreateTracingConnection with providerInvariantName
/// </summary>
/// <param name="connString">
/// Connection String
/// </param>
/// <param name="providerInvariantName">
/// provider Invariant Name
/// </param>
/// <returns>
/// EFTracingConnection obj
/// </returns>
private static EFTracingConnection CreateTracingConnection(string connString, string providerInvariantName)
{
// based on the example at http://jkowalski.com/2010/04/23/logging-sql-statements-in-entity-frameworkcode-first/
string wrapperConnectionString =
string.Format(@"wrappedProvider={0};{1}", providerInvariantName, connString);
var connection = new EFTracingConnection {ConnectionString = wrapperConnectionString};
return connection;
}