C# (CSharp) WCell.Core.Database SqlUtil.AppendKeyValuePairs Examples

Example #1

File: SqlUtil.cs Project: uvbs/Asda2-Server

        public static string BuildWhere(List <KeyValuePair <string, object> > pairs)
        {
            StringBuilder sb = new StringBuilder();

            SqlUtil.AppendKeyValuePairs(sb, pairs, " AND ");
            return(sb.ToString());
        }

Example #2

File: SqlUtil.cs Project: uvbs/Asda2-Server

        public static string BuildUpdate(KeyValueListBase liste, string where)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("UPDATE " + liste.TableName + " SET ");
            SqlUtil.AppendKeyValuePairs(sb, liste.Pairs, ", ");
            sb.Append(" WHERE ");
            sb.Append(where);
            return(sb.ToString());
        }