execute sql statement in asp.net mvc3 (C#)

c# entity-framework sql

Question

How to execute sql statement in asp.net mvc3 (C#)? I am using Entity Data Model for my asp.net mvc application

I need to execute a sql query ("select * from users where EmailAddress like '%@gmail.com'").

1
3
6/9/2011 11:15:01 AM

Accepted Answer

Is your User entity mapped? In such case yo can use

var users = from u in context.Users
            where u.EmailAddress.EndsWith("@gmail.com")
            select u;

If you don't have User table mapped but you have User class with parameterless constructor and public settable properties with same names as columns in result set you can use:

var users = context.ExecuteStoreQuery<User>("select * from users where EmailAddress like '%@gmail.com'");

in case of ObjectContext API or:

var users = context.Database.SqlQuery<User>("select * from users where EmailAddress like '%@gmail.com'");

If you don't have entity you can execute it as any other ADO.NET command by creating SqlConnection, SqlCommand and calling ExecuteReader on the command.

5
6/9/2011 11:24:08 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow