Problem with Entity Framework Model Designer and SQL_Variant datatype

Question

I have a table that has a column with SQL_Variant type and some other columns with types like int, bigint,... When I add this table to edmx file it adds all columns but the SQL_Variant typed column. Is there a bug or I have to do something to add that column?

Answer 1

The entity framework doesn't support sql_variant. If you have to use that type in your code, you've to use another o/r mapper.