I want to execute custom query to get datetime of DB server select Getdate() using entity framework. How can I do this?
Thanks
-
stackoverflow.com/questions/200617/… The second answer.MrFox– MrFox2010-07-14 12:58:44 +00:00Commented Jul 14, 2010 at 12:58
-
I am using Entity Framework, rather LINQ. this is for LINQMuhammad Akhtar– Muhammad Akhtar2010-07-14 13:01:32 +00:00Commented Jul 14, 2010 at 13:01
-
What's your DB provider? MS SQL Server? MySQL? Oracle? ...Yakimych– Yakimych2010-07-14 13:37:47 +00:00Commented Jul 14, 2010 at 13:37
Add a comment
|
3 Answers
ObjectQuery<DateTime> date = new ObjectQuery<DateTime>("select Getdate()", context)
DateTime now = date.Single();
1 Comment
Muhammad Akhtar
I am getting this exception "The query syntax is not valid."
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.
Comments
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.
Comments
