Question

We are using x-tensive ORM, and i want to implement below query in xtensive.

sql query is following. show table like'ItemMaster'

Means hot to manipulate and access the database table at dynamic time in xtensive orm.

for example , can we create table ,check table exist in DB at dynamic time in xtensive.

Answer 1

Maybe this what you want

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

using (var cmd = accessor.CreateCommand())
{
    cmd.CommandText = "do something";
    cmd.CommandType = CommandType.Text;

    /*  
        Add some parameters if needed

        var p = cmd.CreateParameter();
        p.Value = value;
        p.ParameterName = name;
        cmd.Parameters.Add(p);
    */

    // Now get results
    var val = cmd.ExecuteScalar(); // if query return scalar value
    using (var reader = cmd.ExecuteReader()) // if query return table value, get rows will be while(reader.Read())
    cmd.ExecuteNonQuery(); // if we don't bother about return value
}

Subscription:

Related questions