public static string GetKeyValues(Column[] columns, string prefix) { string returnString = ""; for (int i = 0; i < columns.Length; i++) { Column column = columns[i]; returnString += prefix + column.Alias; if (CSharp.MapColumnType.IsInstanceOfType(column) || (column.IsNullable && CSharp.ColumnIsBasicDataType(column))) { returnString += ".Value"; } if (i < columns.Length - 1) { returnString += ", "; } } return(returnString); }
public static string GetASCXConversion(Column column) { string nullableType = ""; if (column.IsNullable && CSharp.ColumnIsBasicDataType(column)) { nullableType += ".Value"; } switch (column.DataType) { case "bigint": return(nullableType + ".ToString()"); case "binary": return(nullableType + ".ToString()"); case "bit": return(nullableType + ""); case "char": return(nullableType + ""); case "datetime": return(nullableType + ".ToString(\"dd MMM yyyy\")"); case "decimal": return(nullableType + ".ToString()"); case "float": return(nullableType + ".ToString()"); case "image": return(nullableType + ".ToString()"); case "int": return(nullableType + ".ToString()"); case "money": return(nullableType + ".ToString()"); case "nchar": return(nullableType + ""); case "ntext": return(nullableType + ""); case "numeric": return(nullableType + ".ToString()"); case "nvarchar": return(nullableType + ""); case "real": return(nullableType + ".ToString()"); case "smalldatetime": return(nullableType + ".ToString(\"dd MMM yyyy\")"); case "smallint": return(nullableType + ".ToString()"); case "smallmoney": return(nullableType + ".ToString()"); case "sql_variant": return(nullableType + ".ToString()"); case "text": return(nullableType + ""); case "timestamp": return(nullableType + ".ToString()"); case "tinyint": return(nullableType + ".ToString()"); case "uniqueidentifier": return(nullableType + ".ToString()"); case "varbinary": return(nullableType + ".ToString()"); case "varchar": return(nullableType + ""); case "xml": return(nullableType + ""); default: throw new Exception(column.DataType + " data type not supported by the ArchAngel.Providers.Database.Model API yet. Please contact Slyce support: [email protected]"); } }