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; }