地图SQL查询到NHibernate的业务对象 [英] Map SQL Query to Business object in Nhibernate
问题描述
我要地图的SQL查询业务对象
使用 NHibernate的
。有在Employee表许多领域,但我只得到三要映射只有那些之一。
I want to map SQL query to Business object
using Nhibernate
. There are lot fields in Employee table, but I am getting three only and want map only those one.
这是我的SQL查询
<sql-query name="findEmployeesInfo">
<return alias="emp" class="Calibr.BusinessDocuments.BOs.Employee, BusinessDocuments"/>
<![CDATA[
select (emp.Eid) as {emp.Id},(emp.FirstName) as {emp.FirstName},(emp.LastName) as {emp.LastName} from Employee emp
]]>
</sql-query>
这是我必须做的构造那些列映射
here is I have make constructor to map those columns
public Employee(int Id, string FirstName, string LastName)
{
this.Id = Id;
this.FirstName = FirstName;
this.LastName = LastName;
}
DB Employee表列名称:开斋节,名字,姓氏,............
DB Employee table Column Names: Eid, FirstName,LastName,............
我得到这个例外
无法执行查询
[选择(emp.Eid)为Eid1_0 _(emp.FirstName)为FirstName1_0 _(emp.LastName)作为LastName1_0_从员工EMP
could not execute query [ select (emp.Eid) as Eid1_0_,(emp.FirstName) as FirstName1_0_,(emp.LastName) as LastName1_0_ from Employee emp
编辑:如果我选择所有列,它的工作完美 - SELECT * FROM员工EMP
if I select all columns, it will work perfect -- Select * from Employee emp
感谢您的帮助。
推荐答案
我想你会使用受益NHibernate的<一个href=\"http://lostechies.com/jimmybogard/2010/06/30/ad-hoc-mapping-with-nhibernate/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%253A%20LosTechies%20%2528LosTechies%2529\"相对=nofollow>特设映射特点:
I think you would benefit from using NHibernate's ad-hoc mapping features:
命名查询:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<sql-query name="findEmployeesInfo">
select emp.Eid as Id, emp.FirstName FirstName, emp.LastName as LastName from Employee emp
</sql-query>
</hibernate-mapping>
Employee类:
public class Employee
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
// etc...
}
即席查询:
IList<Employee> employees = session
.GetNamedQuery("findEmployeesInfo")
.SetResultTransformer(Transformers.AliasToBean(typeof(Employee)))
.List<Employee>();
这篇关于地图SQL查询到NHibernate的业务对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!