NHibernateOscar 1.0.1

快速开始

配置文件 nhibernate.cfg.xml

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
  <session-factory>
    <property name="connection.driver_class">
      NHibernate.Driver.OscarDriver,OscarNHibernate
    </property>
    <property name="connection.connection_string">
      Server=127.0.0.1;Port=2003;User Id=SYSDBA;Password=szoscar55;Database=OSRDB
    </property>
    <property name="adonet.batch_size">10 </property>
    <property name="show_sql">true</property>
    <property name="dialect">
      NHibernate.Dialect.OscarDialect,OscarNHibernate
    </property>
    <property name="command_timeout">10</property>
    <property name="query.substitutions">
      true 1, false 0,yes 'Y', no 'N'
    </property>
    <mapping assembly="DomainModel"/>
  </session-factory>
</hibernate-configuration>

注意： 确保配置文件发布被编译到项目发布包中 请确保 .csproj 配置中有一下内容

<ItemGroup>
    <None Remove="nhibernate.cfg.xml" />
  </ItemGroup>

  <ItemGroup>
    <EmbeddedResource Include="nhibernate.cfg.xml">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
    </EmbeddedResource>
  </ItemGroup>

使用用例

using DomainModel.Domain;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using NHibernate;
using NHibernate.Cfg;
using System;
using System.Data.OscarClient;
using System.Linq;

namespace NETStandardTest
{
    [TestClass]
    public class UnitTest1
    {
        [TestMethod]
        public void TestMethod()
        {
            try
            {
                Configuration cfg = new Configuration();
                cfg.Configure("nhibernate.cfg.xml");

                using ISessionFactory factory = cfg.BuildSessionFactory();
                using var session = factory.OpenSession();
                ITransaction trans = session.BeginTransaction();
                var np = new Product();
                np.Id = 18;
                np.Name = "zeng";

                session.Save(np);
                trans.Commit();
            }
            catch (Exception ex)
            {
                Assert.Fail(ex.Message);
            }
        }

        [TestMethod]
        public void TestSkipTakeMethod()
        {
            try
            {
                Configuration cfg = new Configuration();
                cfg.Configure("nhibernate.cfg.xml");

                using ISessionFactory factory = cfg.BuildSessionFactory();
                using var session = factory.OpenSession();
                var list = session.Query<Product>().Where(u => u.Name == "zeng").Skip(1).Take(1).ToList();
                list = session.Query<Product>().Where(u => u.Name == "zeng").Skip(0).Take(2).ToList();
                list = session.Query<Product>().Where(u => u.Name == "zeng").Skip(1).Take(3).ToList();
                list = session.Query<Product>().Where(u => u.Name == "zeng").Take(3).ToList();
                list = session.Query<Product>().Where(u => u.Name == "zeng").Skip(1).ToList();
            }
            catch (Exception ex)
            {
                Assert.Fail(ex.Message);
            }
        }
    }
}