How to execute sql queries command and retrieve its value?

[navirius]

I want to retrieve server datetime, how can I achieve this?
ex. in my sql "select now()" in sql server "select getdate()"

[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.