使用 Fluent nHibernate 将单个类映射到两个表中的列

发布于 2024-08-20 23:16:23 字数 801 浏览 3 评论 0原文

我有以下数据库表：

TABLE dbo.Client
(
  ClientId PK uniqueidentifier ,
  ClientNames VARCHAR(200)
)

TABLE dbo.User
(
  userID PK UniqueIdentifier,
  password varchar(15),
  passwordsalt varchar(15),
  ClientID FK uniqueidentifier
)

我想将它们映射到我的类：

 public class Client
 {
   public virtual Guid Id {get;set;}
   public virtual string Name {get;set;}
   public virtual string password {get;set;}
   public virtual string passwordsalt {get;set;}
 }

原谅 vb...）

 Public Class ClientMap
   Inherits ClassMap(Of Client)

   Public Sub New()
     Me.Id(Function(x) x.Id, "ClientID")
     Me.Map(Function(x) x.Name, "ClientNames")
   End Sub

 End Class

我已将映射排序到客户端表中的位（请密码盐属性到用户表中的相应列？

预先感谢，

保罗

原文

I have the following database tables:

TABLE dbo.Client
(
  ClientId PK uniqueidentifier ,
  ClientNames VARCHAR(200)
)

TABLE dbo.User
(
  userID PK UniqueIdentifier,
  password varchar(15),
  passwordsalt varchar(15),
  ClientID FK uniqueidentifier
)

I want to map them to my class:

 public class Client
 {
   public virtual Guid Id {get;set;}
   public virtual string Name {get;set;}
   public virtual string password {get;set;}
   public virtual string passwordsalt {get;set;}
 }

I've sorted the mapping to the bits in the client table (excuse the vb...)

 Public Class ClientMap
   Inherits ClassMap(Of Client)

   Public Sub New()
     Me.Id(Function(x) x.Id, "ClientID")
     Me.Map(Function(x) x.Name, "ClientNames")
   End Sub

 End Class

How do I go about mapping the password & passwordsalt properties to the corresponding columns in the users table?

Thanks in advance,

Pau

分享到QQ

分享到微博

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

发布评论

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

罪#恶を代价 2024-08-27 23:16:23

好的，解决了这个问题...

我的映射文件现在看起来像：

Public Sub New()
  Me.Id(Function(x) x.Id, "ClientID")
  Me.Map(Function(x) x.FullNames, "ClientNames")
  Me.Join("Users", AddressOf AddUsersTableInfo)
End Sub

Public Sub AddUsersTableInfo(ByVal m As JoinPart(Of Client))
  m.Map(Function(x) x.PasswordSalt, "passwordSalt")
  m.Map(Function(x) x.Password, "password")
End Sub

喜欢 VB :o(

Ok, solved this problem...

My mapping file now looks like:

Public Sub New()
  Me.Id(Function(x) x.Id, "ClientID")
  Me.Map(Function(x) x.FullNames, "ClientNames")
  Me.Join("Users", AddressOf AddUsersTableInfo)
End Sub

Public Sub AddUsersTableInfo(ByVal m As JoinPart(Of Client))
  m.Map(Function(x) x.PasswordSalt, "passwordSalt")
  m.Map(Function(x) x.Password, "password")
End Sub

Got to love VB :o(

回复收藏 0 原文

~没有更多了~