Page 1 of 1
How to execute sql queries command and retrieve its value?
Posted: Fri 19 Jul 2013 08:00
by navirius
I want to retrieve server datetime, how can I achieve this?
ex. in my sql "select now()" in sql server "select getdate()"
Re: How to execute sql queries command and retrieve its value?
Posted: Mon 22 Jul 2013 09:54
by MariiaI
You could do it via the
DataContext.ExecuteQuery method, for example:
1) SQL Server:
Code: Select all
var data = dt.ExecuteQuery<DateTime>("select getdate();");
2) MySQL:
Code: Select all
var data = dt.ExecuteQuery<DateTime>("select now();");
There is also another universal way:
Code: Select all
var data = dt.NonEmptyTable.Take(1).Select(t => DateTime.Now).First();
JIC: the NonEmptyTable table - any table that is available in your model, but it must necessarily be non-empty.