HQL转化SQL字段大小写问题

在NHibernate的应用中,添加Entity层,添加实体类和Mappings文件。

实体层 SupplierEntity

HQL转化SQL字段大小写问题
public class SupplierEntity 
    {
        /// <summary>
        /// 供应商ID
        /// </summary>
        public virtual int SupplierID { get; set; }
        /// <summary>
        /// 名称
        /// </summary>
        public virtual string Name { get; set; }
        /// <summary>
        /// 联系人
        /// </summary>
        public virtual string Linkman { get; set; }
        /// <summary>
        /// 地址
        /// </summary>
        public virtual string Address { get; set; }
        /// <summary>
        /// 电话
        /// </summary>
        public virtual string Tel { get; set; }
        /// <summary>
        /// 手机
        /// </summary>
        public virtual string Phone { get; set; }
        /// <summary>
        /// 邮编
        /// </summary>
        public virtual string Postcode { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        public virtual string Descr { get; set; }
    }
HQL转化SQL字段大小写问题

SupplierEntity.hbm.xml

HQL转化SQL字段大小写问题
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="TBManage.Entity" namespace="TBManage.Entity">
  <class name="TBManage.Entity.SupplierEntity, TBManage.Entity" table="TSupplier" lazy="false">
    <id name="SupplierID" column="Supplierid" type="Int32">
      <generator class="native" />
    </id>
    <property name="Name" column="Name" type="string" length="50" not-null="true"/>
    <property name="Linkman" column="Linkman" type="string" length="50"/>
    <property name="Address" column="Address" type="string" length="50"/>
    <property name="Phone" column="Phone" type="string" length="50"/>
    <property name="Postcode" column="Postcode" type="string" length="50"/>
    <property name="Descr" column="Descr" type="string" length="200"/>
  </class>
</hibernate-mapping>
HQL转化SQL字段大小写问题

数据库表

HQL转化SQL字段大小写问题
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TSupplier](
    [SupplierID] [int] IDENTITY(1,1) NOT NULL,
    [Name] [varchar](50) NULL,
    [Linkman] [varchar](50) NULL,
    [Address] [varchar](100) NULL,
    [Tel] [varchar](50) NULL,
    [Phone] [varchar](50) NULL,
    [Postcode] [varchar](50) NULL,
    [Descr] [varchar](100) NULL,
    [CreateUser] [varchar](50) NULL,
    [CreateDate] [date] NULL,
    [UpdateUser] [varchar](50) NULL,
    [UpdateDate] [date] NULL,
 CONSTRAINT [PK_T_Supplier] PRIMARY KEY CLUSTERED 
(
    [Supplierid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
HQL转化SQL字段大小写问题

PS:需要特别注意的是:在hbm.xml中,column中Supplierid不可写成SupplierID,否则在HQL转换成sql时,会将SupplierID转换成Supplier_ID,如果数据库字段为Supplier_ID,在hbm.xml中,column中请写为supplier_id。

HQL转化SQL的时,会自动在第二个大写字母之前添加“_”。

具体原因待查证!

HQL转化SQL字段大小写问题,布布扣,bubuko.com

HQL转化SQL字段大小写问题

上一篇:【转】SQL Server 2008 R2 安装出错:Could not open key


下一篇:【亲测可用】MySQL 4.1迁移到MySQL 5.0版本的中文乱码问题解决