internal ExecuteSqlCompleteEventArgs(DbAccess dataAccess, SqlQuery query, DateTime executionStart, DateTime executionFinish, Exception executionException)
: base(dataAccess, query)
{
this.executionStart = executionStart;
this.executionFinish = executionFinish;
this.executionException = executionException;
}
public static IDbAccess CreateDataAccess()
{
DbConnection conn = new OracleConnection("Data Source=localhost;User Id=DENEMELER;Password=1;");
conn.Open();
DbAccess ret = new DbAccess(conn);
ret.ExecuteSqlComplete += (e) =>
{
using (Stream fs = new FileStream("C:\\sql.txt", FileMode.Append, FileAccess.Write))
{
using (StreamWriter sw = new StreamWriter(fs))
{
if (e.Query != null)
{
sw.WriteLine(e.Query.Text.ToString());
sw.WriteLine();
//sw.WriteLine(e.GenerateSqlStatement(':'));
// sw.WriteLine();
sw.WriteLine();
}
}
}
};
return ret;
}
protected override ICommandFactory CreateFactory()
{
SqlConnection conn = new SqlConnection("Data Source=ANKARA;Initial Catalog=PERSONELKOSGEB;User ID=sa;Password=1");
conn.Open();
DbAccess dataAccess = new DbAccess(conn);
dataAccess.ExecuteSqlComplete += (e) =>
{
using (Stream fs = new FileStream("C:\\sql.txt", FileMode.Append, FileAccess.Write))
{
using (StreamWriter sw = new StreamWriter(fs))
{
if (e.Query != null)
{
sw.WriteLine(e.Query.Text.ToString());
sw.WriteLine();
sw.WriteLine();
sw.WriteLine(e.Query.ToParameterlessQuery());
sw.WriteLine();
// sw.WriteLine();
}
}
}
};
AppX.Data.SqlServer.CommandFactory ret = new CommandFactory(dataAccess);
return ret;
}
public static IDbAccess CreateDataAccess()
{
DbConnection conn = new SqlConnection("Data Source=.; Initial Catalog=DENEMELER;User Id=admin;Password=1;");
conn.Open();
DbAccess ret = new DbAccess(conn);
ret.ExecuteSqlComplete += (e) =>
{
lock (sync)
{
using (Stream fs = new FileStream("C:\\sql.txt", FileMode.Append, FileAccess.Write))
{
using (StreamWriter sw = new StreamWriter(fs))
{
if (e.Query != null)
{
//sw.WriteLine(e.Query.Text.ToString());
sw.WriteLine();
sw.WriteLine(e.Query.ToParameterlessQuery());
// sw.WriteLine();
sw.WriteLine();
}
}
}
}
};
return ret;
}
internal PreExecuteSqlEventArgs(DbAccess dataAccess, SqlQuery query)
{
this.dataAccess = dataAccess;
this.query = query;
}
internal IDbAccess CreateDbAccess()//Burası Duruma Göre İleride web servislerine Geçirilebilir.
{
DbConnection conn = DataUtils.CreateEmptyConnection(DbType.SqlServer);
conn.ConnectionString = this.Conn.ConnectionString;
conn.Open();
DbAccess ret = new DbAccess(conn);
#if DEBUG
ret.PreExecuteSql += (e) =>
{
try
{
using (Stream fs = new FileStream("C:\\sql.txt", FileMode.Append, FileAccess.Write))
{
using (StreamWriter sw = new StreamWriter(fs))
{
if (e.Query != null)
{
sw.WriteLine(e.Query.ToParameterlessQuery());
sw.WriteLine();
sw.WriteLine();
}
}
}
}
catch { }
};
#endif
return ret;
}
