private static string DbTypeLengthMySQL(string datatype, string Length) { string text = ""; string key; switch (key = datatype.Trim().ToLower()) { case "number": if (Length == "") { text = "4"; goto IL_139; } text = Length; goto IL_139; case "varchar2": if (Length == "") { text = "50"; goto IL_139; } text = Length; goto IL_139; case "char": if (Length == "") { text = "50"; goto IL_139; } text = Length; goto IL_139; case "date": case "nchar": case "nvarchar2": case "long": case "long raw": case "bfile": case "blob": goto IL_139; } text = Length; IL_139: if (text != "") { text = CodeCommon.CSToProcType("MySQL", datatype) + "," + text; } else { text = CodeCommon.CSToProcType("MySQL", datatype); } return(text); }
private static string DbTypeLengthSQL(string dbtype, string datatype, string Length) { string text = CodeCommon.GetDataTypeLenVal(datatype, Length); string result; if (text != "") { if (text == "MAX") { text = "-1"; } result = CodeCommon.CSToProcType(dbtype, datatype) + "," + text; } else { result = CodeCommon.CSToProcType(dbtype, datatype); } return(result); }
private static string DbTypeLengthSQLite(string datatype, string Length) { string text = ""; string key; switch (key = datatype.Trim()) { case "int": case "integer": if (Length == "") { text = "4"; goto IL_231; } text = Length; goto IL_231; case "varchar": if (Length == "") { text = "50"; goto IL_231; } text = Length; goto IL_231; case "char": if (Length == "") { text = "50"; goto IL_231; } text = Length; goto IL_231; case "bit": text = "1"; goto IL_231; case "float": case "numeric": case "decimal": case "money": case "smallmoney": case "binary": case "smallint": case "bigint": case "blob": text = Length; goto IL_231; case "image": case "datetime": case "smalldatetime": case "nchar": case "nvarchar": case "ntext": case "text": case "time": case "date": case "boolean": goto IL_231; } text = Length; IL_231: if (text != "") { text = CodeCommon.CSToProcType("SQLite", datatype) + "," + text; } else { text = CodeCommon.CSToProcType("SQLite", datatype); } return(text); }