Azavea.Open.DAO.SQL.SqlUtilities.MakeInsertStatement C# (CSharp) Method

SqlUtilities Class Documentation Datei anzeigen Open project: azavea/net-dao

MakeInsertStatement() public static method

Generates an insert statement to insert the values from the dictionary into the specified table. Uses parameters for the values, the values will be taken from the dictionary and inserted into sqlParams in the same order the column names are inserted in the sql string.
public static MakeInsertStatement ( string table, object>.IDictionary columns, IList sqlParams ) : string
table string Name of the table to be inserted into.
columns object>.IDictionary Dictionary of object column values keyed by string column names.
sqlParams IList List to insert sql param values (in order) into.
return string 
        public static string MakeInsertStatement(string table, IDictionary<string, object> columns,
            IList<object> sqlParams)
        {
            return MakeInsertStatement(table, columns, sqlParams, new Dictionary<string, string>());
        }

Same methods

SqlUtilities::MakeInsertStatement ( string table, object>.IDictionary columns, IList sqlParams, string>.IDictionary valueStrings ) : string
SqlUtilities
FindParameterPlaceholders
MakeDeleteStatement
MakeInsertStatement
MakeUpdateStatement
MakeWhereClause
SqlParamsToString