Using NHibernate to execute DDL statements

Question

How can I execute a DDL statement via NHibernate?

To be clear, I don't want to auto-generate my schema from my mapping files. My DDL is stored in plain text files along the lines of:

CREATE TABLE Foo (Bar VARCHAR(10))
GO
CREATE TABLE Hello (World INTEGER)
GO

I want to cycle through these in order and execute each of them. I could just open a SqlConnection and execute via a SqlCommand but I'd like to go through NHibernate if there is a nice way to do this. This is mainly because I want to remain as database agnostic as possible: I have a SQL db now but I might need to implement Oracle or DB2 later...

I'm using .Net v3.51 and NHibernate v2.1. I looked at the NHibernate SchemaExport class but couldn't see a way to use this for this purpose.

David Hogue · Accepted Answer · 2010-01-07 19:50:36Z

3

I've used session.Connection.CreateCommand and session.Transaction.EnlistCommand before with success to run raw SQL.

Here's a snippet of something similar that I've done:

using (var command = _session.Connection.CreateCommand())
{
    _session.Transaction.Enlist(command);
    command.CommandText = "select foo from bar where id = @id";
    var versionIdParameter = command.CreateParameter();
    versionIdParameter.ParameterName = "id";
    versionIdParameter.Value = id;
    command.Parameters.Add(versionIdParameter);
    using(var reader = command.ExecuteReader(CommandBehavior.SequentialAccess))
    {
        while (reader.Read())
        // ...
    }
}

answered Jan 7, 2010 at 19:50

David Hogue

1,8411 gold badge16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jamie Ide · Accepted Answer · 2010-01-07 19:46:17Z

2

You can get an IDbConnection from an ISession's Connection property but you'll need to do this with SqlCommand. Executing DDL is outside of NHibernate's scope.

answered Jan 7, 2010 at 19:46

Jamie Ide

49.4k18 gold badges85 silver badges118 bronze badges

2 Comments

Steve Over a year ago

I want to make this database agnostic - is there a straightforward way of doing this e.g. will Nhibernate give me an IDbCommand?

Jamie Ide Over a year ago

Calling IDbConnection.CreateCommand returns an IDbCommand. But I don't think you can achieve database agnostic DDL except for simple cases.

Collectives™ on Stack Overflow

Using NHibernate to execute DDL statements

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related