public DbCommand GetInsertCommand(object[] parameters) { if (TYPE != TableSchamaType.TABLE) { return(null); } if (_schama.Count <= 0) { return(null); } var sb_param = new StringBuilder(); var lst_params = new List <DbParameter>(); var items = _schama.OrderBy(itm => itm.ColumnOrdinal); foreach (var item in items) { if (item.ColumnOrdinal >= parameters.Length) { break; } if (sb_param.Length > 0) { sb_param.Append(","); } var parameter = DBAccessor.CreateParameter(string.Format("COL{0}", item.ColumnOrdinal), parameters[item.ColumnOrdinal]); sb_param.Append(parameter.ParameterName); lst_params.Add(parameter); } var sql = string.Format(SQL_INSERT_1, TableName, sb_param.ToString()); return(DBAccessor.CreateCommand(sql, lst_params.ToArray())); }