i need use sql_variant in entity framework code first

Asked Mar 03 '13 at 12:37

Active Mar 03 '13 at 12:37

Viewed 1,845 times

i have to define dynamic parameters value in database for invoke my methods in C# by these parameters. BTW,i just use simple varibale such as int,bool,string,datetime.... but unfortunately i can't get value from sql_variant field to object in my model.

i use EF code First 5 and SQL 2008 Server

asked Mar 03 '13 at 12:37

Mahdi Farhani

It is not supported - use direct SQL through ADO.NET. – Ladislav Mrnka Mar 04 '13 at 07:47
So you also can't use `sql_variant`. One way to get result from [sql_variant](http://www.codeproject.com/Articles/137509/Reading-sql_variant-in-Entity-Framework) is this work around but it doesn't work with code first - you need EDMX. – Ladislav Mrnka Mar 05 '13 at 08:24
do you have any suggestion to do it with code first and without SQL_Variant ? – Mahdi Farhani Mar 05 '13 at 08:41

i need use sql_variant in entity framework code first

0 Answers0