Question

I'm trying to execute SQL directly (with DO.NET installed from Nuget);

I do the following

var directSql = Session.Services.Demand<DirectSqlAccessor>();
var command = directSql.CreateCommand();
command.CommandText = "update MyTable set [Field] = 0";
command.ExecuteNonQuery();

and get the following error:

Error   7   'Xtensive.IoC.IServiceContainer' does not contain a definition
for 'Demand' and no extension method 'Demand' accepting a first argument of type
'Xtensive.IoC.IServiceContainer' could be found (are you missing a using directive 
or an assembly reference?)

Accepted Answer

Hello Charles,

Demand() is an extension method, you need to import Xtensive.Core namespace to use it.

Alternatively you could just call Get() method:

var directSql = Session.Services.Get<DirectSqlAccessor>();

Difference between Demand and Get is in handling of unknown services: Get returns null reference, Demand throws exception.

Since DirectSqlAccessor is a standard service it is always available.

Subscription:

Related questions