Hi,
I have a scenario where I need the SQL Server data type of each field, so I mean something like the SqlDbType enum.
When I get the DataType from the Entity what I get is a .NET Type, but in some cases I can't distinguish if the data type is binary, image, varbinary, timestamp because all of them are converted to byte[].
Is there any way I can get the Sql Server data type from the Entity?
The only solution I can imagine is to execute a raw SQL query like
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
and get the data type from there, cast the data type to the enum
(SqlDbType)Enum.Parse(typeof(SqlDbType), typeName, true)
By the way, I'm using LLBLGEN 4.2 with no option to upgrade to version 5.
Thanks.