In the method string GetSysType(string sqlType) some types are missing:
the type text, and the type timestamp are missing.
The method should be:
string GetSysType(string sqlType){
string sysType="string";
switch (sqlType) {
case "bigint":
sysType = "long";
break;
case "smallint":
sysType= "short";
break;
case "int":
sysType= "int";
break;
case "uniqueidentifier":
sysType= "Guid";
break;
case "smalldatetime":
case "datetime":
sysType= "DateTime";
break;
case "float":
sysType="double";
break;
case "real":
case "numeric":
case "smallmoney":
case "decimal":
case "money":
sysType= "decimal";
break;
case "tinyint":
sysType= "int";
break;
case "bit":
sysType= "bool";
break;
case "image":
case "binary":
case "varbinary":
sysType= "byte[]";
break;
case "text":
sysType= "string";
break;
case "timestamp":
sysType= "byte[]";
break;
In the method string GetSysType(string sqlType) some types are missing:
the type text, and the type timestamp are missing.
The method should be:
string GetSysType(string sqlType){ string sysType="string"; switch (sqlType) { case "bigint": sysType = "long"; break; case "smallint": sysType= "short"; break; case "int": sysType= "int"; break; case "uniqueidentifier": sysType= "Guid"; break; case "smalldatetime": case "datetime": sysType= "DateTime"; break; case "float": sysType="double"; break; case "real": case "numeric": case "smallmoney": case "decimal": case "money": sysType= "decimal"; break; case "tinyint": sysType= "int"; break; case "bit": sysType= "bool"; break; case "image": case "binary": case "varbinary": sysType= "byte[]"; break; case "text": sysType= "string"; break; case "timestamp": sysType= "byte[]"; break;
}