public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { var a = sql.ToString(); System.Console.WriteLine(sql.ToString()); return(sql); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { string qry = sql.ToString(); //Trace.WriteLine(qry); return(sql); }
public NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql, ILogger <SqlStatementInterceptor> logger) { logger.Log(LogLevel.Error, "ERRRRRRRRRRRRRRRRRRRRRRRRROR!"); logger.Log(LogLevel.Error, sql.ToString()); SQLString.NHibernateSQLString = sql.ToString(); return(sql); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { //System.Diagnostics.Trace.WriteLine("??" + sql.ToString() + "??"); //System.Diagnostics.Debug.WriteLine(sql.ToString()); //System.Console.WriteLine(sql.ToString()); return(sql); }
public override IDbCommand GenerateCommand(CommandType type, NHibernate.SqlCommand.SqlString sqlString, NHibernate.SqlTypes.SqlType[] parameterTypes) { SqlCommand command = (SqlCommand)base.GenerateCommand(type, sqlString, parameterTypes); LogCommand(command); return(command); }
public NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { if (GetDataFromConfigurationManagement) { sql = FilterSQLToAvoidOtherUsersNewObjects(sql); } return(sql); }
//public string your property{ get; set; } NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { NHSessionManager.Instance.NHibernateSQL = sql.ToString(); //property = sql.ToString(); //Or //AsignSqlToSomeGlobalVariable(sql.ToString()); return(sql); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { //if (NumberOfRequests++ > 10) //{ // new SoundPlayer("http://www.shockwave-sound.com/sound-effects/scream-sounds/2scream.wav").PlaySync(); //} return(base.OnPrepareStatement(sql)); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { if (SqlStatementInterceptor.LogSQLOn) { SqlStatementInterceptor.LogSQL += "\n" + sql; } return(sql); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { foreach (var partitionId in partitionIds) { sql = sql.Replace(partitionId.TableName, partitionId.RealTableName); } return(base.OnPrepareStatement(sql)); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { if (this.ActiveListener != null) { this.ActiveListener.OnPrepareStatement(sql.ToString()); } return(base.OnPrepareStatement(sql)); }
private NHibernate.SqlCommand.SqlString FilterSQLToAvoidOtherUsersNewObjects(NHibernate.SqlCommand.SqlString sql) { string sqlstr = sql.ToString(); if (sqlstr.Contains(".LockedBy") && sqlstr.Contains(".State")) { int whereindex = sqlstr.IndexOf(" WHERE ", StringComparison.OrdinalIgnoreCase); int orderbyIndex = sqlstr.IndexOf(" ORDER BY ", StringComparison.OrdinalIgnoreCase); int fromIndex = sqlstr.IndexOf(" FROM ", StringComparison.OrdinalIgnoreCase); string tableSynonym = string.Empty; int substringLength = sqlstr.IndexOfAny(new char[] { ' ', ',' }, sqlstr.IndexOf(' ', fromIndex + 6) + 1) - sqlstr.IndexOf(' ', fromIndex + 6) - 1; if (substringLength > 0) { tableSynonym = sqlstr.Substring(sqlstr.IndexOf(' ', fromIndex + 6) + 1, substringLength); } else { tableSynonym = sqlstr.Substring(sqlstr.IndexOf(' ', fromIndex + 6) + 1); } tableSynonym += "."; string whereStatment = " ((" + tableSynonym + "LockedBy is null) OR (" + tableSynonym + "LockedBy = '" + Environment.UserName + "') OR (" + tableSynonym + "LockedBy <> '" + Environment.UserName + "' AND " + tableSynonym + "State <> 1))"; if (whereindex > -1) { if (sqlstr.LastIndexOf(".LockedBy") < whereindex && sqlstr.LastIndexOf(".State") < whereindex) { if (orderbyIndex > -1) { sql = sql.Insert(orderbyIndex, " AND" + whereStatment); } else { sql = sql.Append(" AND" + whereStatment); } } } else { if (orderbyIndex > -1) { sql = sql.Insert(orderbyIndex, " WHERE" + whereStatment); } else { sql = sql.Append(" WHERE" + whereStatment); } } } return(sql); }
/// <summary> /// Convert sql string to list /// </summary> /// <param name="subject"></param> /// <returns>List of strings representing the prepared statement</returns> public static string[] ConvertSqlPartsToStringArray( NHibernate.SqlCommand.SqlString subject) { var _sqlPartsAsStringArray = new string[subject.Parts.Count]; var _i = 0; foreach (var _part in subject.Parts) { _sqlPartsAsStringArray[_i] = _part.ToString(); _i++; } return(_sqlPartsAsStringArray); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { LogHelper.SaveSQLToLog(sql.ToString()); return(base.OnPrepareStatement(sql)); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { Trace.WriteLine("NHibernate SQL: " + sql.ToString()); return(sql); }
NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { return(sql.Replace("Region=0", "Region<>0")); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { return(base.OnPrepareStatement(sql)); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { Debug.Print(sql.ToString()); return(base.OnPrepareStatement(sql)); }
public NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { return(sql); }
/// <summary> /// The prepared SQL statement is copied to <see cref="NHibernateSql.LastSqlStatement"/>. /// </summary> /// <param name="sqlStatement">The <see cref="NHibernate.SqlCommand.SqlString"/> to be prepared.</param> /// <returns>A <see cref="NHibernate.SqlCommand.SqlString"/>.</returns> NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sqlStatement) { NHibernateSql.LastSqlStatement = sqlStatement.ToString(); return(sqlStatement); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { Debug.WriteLine(sql.ToString()); return(sql); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { PrepareStatement?.Invoke(this, EventArgs.Empty); return(base.OnPrepareStatement(sql)); }
// http://stackoverflow.com/questions/2134565/how-to-configure-fluent-nhibernate-to-output-queries-to-trace-or-debug-instead-o public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { Mapper.NHibernateSQL = sql.ToString(); return(sql); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { System.Diagnostics.Trace.WriteLine(sql.ToString()); return(sql); }
NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { return(sql.Replace("{MASTER_USER}", MASTER_USER).Replace("{TRAN_USER}", TRAN_USER)); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { logger.LogTrace(sql.ToString()); return(sql); }
public override orm.SqlCommand.SqlString OnPrepareStatement(orm.SqlCommand.SqlString sql) { return(sql);//Query Sql gerada pelo nHibernate }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { System.Diagnostics.Debug.WriteLine("sql语句:" + sql); return(base.OnPrepareStatement(sql)); }
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql) { Trace.WriteLine(base.OnPrepareStatement(sql).ToString()); Console.WriteLine(base.OnPrepareStatement(sql).ToString()); return(sql); }