Executing Custom query -- Entity Framework

Question

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

Thanks

http://stackoverflow.com/questions/200617/how-do-i-use-sqls-getdate-and-dateadd-in-a-linq-to-sql-expression The second answer. — MrFox, Jul 14 '10 at 12:58

score 4 · Accepted Answer · edited Mar 05 '12 at 15:08

4

ObjectQuery<DateTime> date = new ObjectQuery<DateTime>("select Getdate()", context)
DateTime now = date.Single();

edited Mar 05 '12 at 15:08

chris

36,094
53
157
237

answered Jul 14 '10 at 13:09

Kikaimaru

1,841
1
16
28

I am getting this exception "The query syntax is not valid." – Muhammad Akhtar Jul 14 '10 at 13:21

Julien N · Answer 2 · 2011-08-02T08:49:19.323

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.

score -1 · Answer 3 · answered Oct 05 '10 at 22:30

Public Function GetDateTimeFromServer() As DateTime
    Using context As New NorthwindEntities()
        Dim dateQry As IQueryable(Of DateTime) = From bogus In context.Products_
            Select DateTime.Now
        Dim result As DateTime = dateQry.First()
        Return result
    End Using
End Function

You can use a query against a table (e.g. Products) and make sure you don't select any columns in the table as shown in the above code. It is not elegant but it works.

Executing Custom query -- Entity Framework

3 Answers3