public static ScalarBuiler CreateBuilder() { var builder = new ScalarBuiler(); builder.SqlParameters = new List <SqlParameter>(); return(builder); }
public static ScalarBuiler CreateScalarWhere(string where, object[] paras) { string[] parts = where.Split('?'); StringBuilder sb = new StringBuilder(); ScalarBuiler builder = ScalarBuiler.CreateBuilder(); for (int i = 0; i < parts.Length; i++) { sb.Append(parts[i]); if (i < parts.Length - 1) { object p = null; if (i > paras.Length - 1) { p = paras[paras.Length - 1]; } else { p = paras[i]; } sb.Append(builder.AddParameter(p)); } } builder.Where = sb.ToString(); return(builder); }