Using Entity Framework to run a custom query

c# entity-framework winforms

Question

I want to execute custom query to get datetime of DB server select Getdate() using entity framework. How can I do this?

Thanks

1
1
7/14/2010 12:54:07 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

ObjectQuery<DateTime> date = new ObjectQuery<DateTime>("select Getdate()", context)
DateTime now = date.Single();
4
3/5/2012 3:08:44 PM

Popular Answer

You can try somethink like that :

public static partial class ObjectContextExtension
{
    public static T ExecuteScalarCommand<T>(this ObjectContext context, string command)
    {
        DbConnection connection = ((EntityConnection)context.Connection).StoreConnection;
        if (connection.State == ConnectionState.Closed)
            connection.Open();

        DbCommand cmd = connection.CreateCommand();
        cmd.CommandText = command;
        cmd.CommandType = CommandType.Text;

        return (T)cmd.ExecuteScalar();
    }

It add the method "ExecuteScalarCommand" to the ObjectContext.
You just give the SQL request as parameter and the return type for the generic type.

Julien N

Related Questions

In Microsoft Entity Model Framework, how to run a SQL Raw Query

I'm using Microsoft Entity model framework to access my database. I get an issue while i use this execute query command for executing Sql raw query. Let me know how could i resolve it. ...svdc.CreateQuery<VideoMasterTable>( "select * from videomastertable WHERE FREETEXT(*, '"+keyword+"')" ).ToList(); ...Thanks in Advance,...Kanal
c# entity-framework linq-to-entities search
asked by kamal

Dynamically query entities from Entity Framework for association to primary Entity

I know the title wasn't the greatest, but here is what I actually want to accomplish....I have a details view that represents Entity1 and its associations. I am capturing the property names and values in a key/value pair. I am currently using reflection to set the Entity properties to the corresponding values for non associations. I doubt this is t...
c# dynamic-queries entity-framework expression-trees reflection
asked by m4chine

Entity Framework query ToString won't produce SQL query

Through my research I've discovered that, since at least EF 4.1, the .ToString() method on an EF query will return the SQL to be run. Indeed, this very frequently works for me, using Entity Framework 5 and 6....However, occasionally I call this method and get the runtime type of the query object. Here is my specific example:...Entity input = ...; I...
c# entity-framework entity-framework-5 entity-framework-6
asked by TheRubberDuck

Log Queries executed by Entity Framework DbContext

You can use this line to log the SQL queries to the Visual Studio "Output" window only and not to a console window, again in Debug mode only....public class YourContext : DbContext { public YourContext() { Database.Log = sql => Debug.Write(sql); } }
asp.net-mvc-5 c# entity-framework entity-framework-6 linq
asked by Dennis Mieszala

Get max & min from Entity Framework, in one query and with best query possible

I'm aware of ...this... question, but what I would like to do is obtain something close to this generated SQL:...select MAX(Column), MIN(Column) from Table WHERE Id = 1 ...When I try this:...var query = from d in db.Table where d.Id == 1 select new { min = db.Table.Max(s => s.Column), ...
c# entity-framework generated-sql linq
asked by Benjol

Client side query builder (jquery) to Entity Framework query

I want to ask how can I build a query builder engine same like TFS uses for queries that will allow user to combine multiple conditions and in the backend will use EF in order to query the data based on the conditions....Something like: user builds the query -> send json to backend -> backend process query as EF code first + repository pattern....T...
c# entity-framework-6 linq repository-pattern unit-of-work
asked by David Dury

How to execute insert query using Entity Framework

I am trying to execute a insert query using Entity Framework....I have something like this:...Context.database.ExecuteSqlCommand("Insert into tableName Values({0},{1},{2}", param1, param2, param3) ...but this is throwing an error...incorrect syntax near '@p1'...What is this '@p1' ?
.net c# entity-framework sql
asked by Ajay George

How to execute raw SQL query using Entity Framework without having to use a model?

I am trying to learn C# ASP.NET MVC 5. And I am trying to use Entity Framework for everything I do. ...However, I need to run a raw SQL query and return the results into an array....Here is what I have done so far....I created my context class which allows me to connect to a server and it also allows me to change the database at run time....Here is...
asp.net asp.net-mvc asp.net-mvc-5 c# entity-framework
asked by Junior

Entity Framework .NET Core 2.0 Query hangs on execution when subquery is executed

With a regular version of EF 6.x I was able to do subqueries pretty easy with the following query:...var q = from u in db.User let actions = from ua in db.UserActions where ua.UserId == u.Id && ua.Approved select ua where u.Active select new { User = u, Actions = actions.ToList() }...
c# entity-framework entity-framework-6 entity-framework-core sql
asked by Alexey Strakh

Entity Framework 6 mapping a custom SQL query to an Entity

This is the solution to my problem. Basically manually creating an Entity within the XML and mapping it to a virtual table....Entity Framework DefiningQuery
asp.net-mvc c# entity-framework entity-framework-6
asked by Braden

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

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