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);
}
