使用NHibernate执行DDL语句

发布于 2024-08-17 03:18:46 字数 462 浏览 4 评论 0原文

如何通过 NHibernate 执行 DDL 语句？

需要明确的是，我不想从映射文件自动生成架构。我的 DDL 存储在纯文本文件中，格式如下：

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

我想按顺序循环遍历这些文件并执行它们中的每一个。我可以打开一个 SqlConnection 并通过 SqlCommand 执行，但如果有一个好的方法来执行此操作，我想通过 NHibernate。这主要是因为我想尽可能保持与数据库无关：我现在有一个 SQL 数据库，但稍后我可能需要实现 Oracle 或 DB2...

我正在使用 .Net v3.51 和 NHibernate v2.1。我查看了 NHibernate SchemaExport 类，但找不到将其用于此目的的方法。

原文

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.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

追我者格杀勿论 2024-08-24 03:18:46

我之前曾使用 session.Connection.CreateCommand 和 session.Transaction.EnlistCommand 成功运行原始 SQL。

这是我做过的类似事情的片段：

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())
        // ...
    }
}

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())
        // ...
    }
}

回复收藏 0 原文