///----------------------------------------------------------------------------------------
/// <summary>
///
/// </summary>
/// <param name="sqlCmd"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public override bool CreateQuery(string sqlCmd, Common.CommandParameter parameters = null)
{
var sqlParameters = parameters as SqlServer.CommandParameter;
bool result = CreateCommand(sqlCmd);
if (result)
{
AddParameters(sqlParameters);
}
return(result);
}
///----------------------------------------------------------------------------------------
/// <summary>
/// Adds parameters to the IDbCommand Parameters property.
/// </summary>
/// <param name="parameters"></param>
public override void AddParameters(Common.CommandParameter parameters)
{
if (_Cmd == null || parameters == null)
{
return;
}
_Cmd.Parameters.Clear();
parameters.AddParameters(_Cmd);
try
{
_Cmd.Prepare();
}
catch (Exception e)
{
Trace.WriteLine($"SqlServer.Database.AddParameters: [{e.Message}]");
}
}
