/// <summary>
/// Build inline paremeterMap
/// </summary>
/// <param name="statement">The statement.</param>
/// <param name="sqlCommandText">The SQL command text.</param>
/// <param name="newSqlCommandText">The newsql command text.</param>
/// <returns></returns>
public ParameterMap BuildInlineParemeterMap(IStatement statement, string sqlCommandText, out string newSqlCommandText)
{
newSqlCommandText = sqlCommandText;
ParameterMap map = null;
// Check the inline parameter
if (statement.ParameterMap == null)
{
// Build a Parametermap with the inline parameters.
// if they exist. Then delete inline infos from sqltext.
SqlText sqlText = InlineParameterMapParser.ParseInlineParameterMap(modelStore.DataExchangeFactory, statement.Id, statement, newSqlCommandText);
if (sqlText.Parameters.Length > 0)
{
string id = statement.Id + "-InLineParameterMap";
string className = string.Empty;
Type classType = null;
IDataExchange dataExchange = null;
if (statement.ParameterClass != null)
{
className = statement.ParameterClass.Name;
classType = statement.ParameterClass;
//dataExchange = modelStore.DataExchangeFactory.GetDataExchangeForClass(classType);
}
if (statement.ParameterClass == null &&
sqlText.Parameters.Length == 1 && sqlText.Parameters[0].PropertyName == "value") //#value# parameter with no parameterClass attribut
{
dataExchange = modelStore.DataExchangeFactory.GetDataExchangeForClass(typeof(int)); //Get the primitiveDataExchange
}
else
{
dataExchange = modelStore.DataExchangeFactory.GetDataExchangeForClass(statement.ParameterClass);
}
map = new ParameterMap(
id,
className,
string.Empty,
classType,
dataExchange,
modelStore.SessionFactory.DataSource.DbProvider.UsePositionalParameters
)
;
int lenght = sqlText.Parameters.Length;
for (int index = 0; index < lenght; index++)
{
map.AddParameterProperty(sqlText.Parameters[index]);
}
}
newSqlCommandText = sqlText.Text;
}
if (statement is Procedure)
{
newSqlCommandText = newSqlCommandText.Replace(MARK_TOKEN, string.Empty).Replace(COMMA_TOKEN, string.Empty);
}
// newSqlCommandText = newSqlCommandText.Trim();
return(map);
}
/// <summary>
/// Initializes a new instance of the <see cref="DynamicSql"/> class.
/// </summary>
/// <param name="usePositionalParameters">if set to <c>true</c> [use positional parameters].</param>
/// <param name="dbHelperParameterCache">The db helper parameter cache.</param>
/// <param name="dataExchangeFactory">The data exchange factory.</param>
/// <param name="statement">The statement.</param>
public DynamicSql(
bool usePositionalParameters,
DBHelperParameterCache dbHelperParameterCache,
DataExchangeFactory dataExchangeFactory,
IStatement statement)
{
Contract.Require.That(dataExchangeFactory, Is.Not.Null).When("retrieving argument dataExchangeFactory in DynamicSql constructor");
Contract.Require.That(dbHelperParameterCache, Is.Not.Null).When("retrieving argument dbHelperParameterCache in DynamicSql constructor");
Contract.Require.That(statement, Is.Not.Null).When("retrieving argument statement in DynamicSql constructor");
this.statement = statement;
this.usePositionalParameters = usePositionalParameters;
this.dataExchangeFactory = dataExchangeFactory;
this.dbHelperParameterCache = dbHelperParameterCache;
paramParser = new InlineParameterMapParser();
}
