///---------------------------------------------------------------------------------------- /// <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}]"); } }