Executing raw sql query using Entity Framework

Question

I use his code for executing SQL query in entity framework :

using (var db = new VSServicesEntities())
            {                 
                const string selectCmd = @"if exists (Select top 1 IsUserOn From ServiceMembers Where ServiceCode=@ServiceCode and Number=@Number) 
                             Select isnull(IsUserOn,0) IsON 
                             From ServiceMembers Where ServiceCode=@ServiceCode and Number=@Number
                          else 
                             Select Null IsON";
                var data = db.ServiceMembers.SqlQuery(selectCmd, number, serviceCode).ToList();
                if (data.Count()>1)
                {

                    //How to acccess value of returned column named IsON
                }

and i want in the if block if (data.Count()>1) to access value of column that returned by executing query, this column's name is IsON, how can i access to it?

XN16 · Accepted Answer · 2014-07-07 12:22:35Z

1

If you are expecting a list of entities, then you will need to determine which one you want with .First(), .Single() or a similar function.

From there it should be a simple case of writing var result = data.First().IsON; to get your value from that column, or something similar. This is the way I do it, you will get an exception if the entity isn't known or the column from the table isn't known either. But from what you have provided, it shouldn't be an issue.

answered Jul 7, 2014 at 12:22

XN16

5,88916 gold badges52 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Executing raw sql query using Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest