嗨，我有一个名为 document 的对象和一个名为 user

文档

    public virtual string Name { get; set; } 
    public virtual string Description { get; set; } 
    public virtual User User { get; set; } 

文档 map

    public DocumentMap() 
    { 
        Map(x => x.Name); 
        Map(x => x.Description); 
        References(x => x.User); 
    } 

用户

    public virtual string UserId { get; set; } 
    public virtual string FirstName { get; set; } 
    public virtual string MiddleInitial { get; set; } 
    public virtual string LastName { get; set; } 
    private readonly IList<Document> _documents = new List<Document>(); 
    public virtual IEnumerable<Document> Documents { get { return _documents; } } 
    public virtual void Remove(Document document) 
    { 
        _documents.Remove(document); 
    } 
    public virtual void Add(Document document) 
    { 
        if (!document.IsNew() && _documents.Contains(document)) return; 
        _documents.Add(document); 
    } 
 
    Map(x => x.UserId); 
        Map(x => x.FirstName); 
        Map(x => x.MiddleInitial); 
        Map(x => x.LastName); 
        HasMany(x => x.Documents).Access.CamelCaseField(Prefix.Underscore);  

非常简单(他们从基类继承了诸如 createddate modifieddate 之类的东西)

当我尝试通过用户 ID 获取所有文档时，我得到了这个

无效的列名“用户 ID”。

该列绝对在表中。它还列出了一些不存在的基类项目。

我拿了 sql 并在查询管理器中传递了它，我得到智能感知说它们是无效的列。我运行它，它执行得很好。此外，还有很多其他对象使用这些基类没有问题。

我尝试了各种方法，例如显式映射键名、使用反向等的列名都无济于事。真不知道该怎么办。
谢谢，
雷夫

//根据请求编辑抱歉它太冗长了。数据库由 nhibernate create schema 创建

文档

public class Document : Entity 
{ 
    public virtual string Name { get; set; } 
    public virtual string Description { get; set; } 
    public virtual DocumentCategory DocumentCategory { get; set; } 
    [ValueOf(typeof(DocumentFileType))] 
    public virtual string FileType { get; set; } 
    public virtual string FileUrl { get; set; } 
    public virtual int? Pages { get; set; } 
    public virtual decimal? Size { get; set; } 
    public virtual User User { get; set; } 
} 
 
public class DocumentMap : EntityMap<Document> 
{ 
    public DocumentMap() 
    { 
        Map(x => x.Name); 
        Map(x => x.Description); 
        Map(x => x.FileUrl); 
        Map(x => x.Pages); 
        Map(x => x.Size); 
        Map(x => x.FileType); 
        References(x => x.DocumentCategory); 
        References(x => x.User); 
    } 
} 

实体

public class Entity : IGridEnabledClass, IEquatable<Entity> 
{ 
    public virtual int EntityId { get; set; } 
    public virtual DateTime? CreateDate { get; set; } 
    public virtual DateTime? ChangeDate { get; set; } 
    public virtual int ChangedBy { get; set; } 
    public virtual bool Archived { get; set; } 
 
    public virtual bool IsNew() 
    { 
        return EntityId == 0; 
    } 

用户

 public class User : DomainEntity, IUser 
{ 
    public virtual string UserId { get; set; } 
    [ValidateNonEmpty] 
    public virtual string FirstName { get; set; } 
    public virtual string MiddleInitial { get; set; } 
    [ValidateNonEmpty] 
    public virtual string LastName { get; set; } 
    public virtual string Title { get; set; } 
    public virtual DateTime? BirthDate { get; set; } 
    public virtual string StartPage { get; set; } 
    public virtual UserLoginInfo UserLoginInfo { get; set; } 
    public virtual UserStatus UserStatus { get; set; } 
    public virtual Photo HeadShot { get; set; } 
    private readonly IList<Document> _documents = new List<Document>(); 
    public virtual IEnumerable<Document> Documents { get { return _documents; } } 
    public virtual void Remove(Document document) 
    { 
        _documents.Remove(document); 
    } 
    public virtual void Add(Document document) 
    { 
        if (!document.IsNew() && _documents.Contains(document)) return; 
        _documents.Add(document); 
    } 
    several more collections 
 
public class UserMap : DomainEntityMap<User> 
{ 
    public UserMap() 
    { 
        Map(x => x.UserId); 
        Map(x => x.FirstName); 
        Map(x => x.MiddleInitial); 
        Map(x => x.LastName); 
        Map(x => x.BirthDate); 
        Map(x => x.StartPage); 
        References(x => x.UserStatus); 
        References(x => x.UserLoginInfo); 
        References(x => x.HeadShot); 
        HasMany(x => x.Documents).Access.CamelCaseField(Prefix.Underscore);  

从脚本选择创建的数据库表到管理工作室的菜单项

  SELECT [EntityId] 
  ,[CreateDate] 
  ,[ChangeDate] 
  ,[ChangedBy] 
  ,[Archived] 
  ,[Name] 
  ,[Description] 
  ,[FileUrl] 
  ,[Pages] 
  ,[Size] 
  ,[FileType] 
  ,[DocumentCategoryId] 
  ,[UserId] 
  FROM [DecisionCriticalSuite].[dbo].[Document] 
 GO 
 
 
  SELECT [EntityId] 
  ,[CreateDate] 
  ,[ChangeDate] 
  ,[ChangedBy] 
  ,[Archived] 
  ,[TenantId] 
  ,[OrgId] 
  ,[UserId] 
  ,[FirstName] 
  ,[MiddleInitial] 
  ,[LastName] 
  ,[BirthDate] 
  ,[StartPage] 
  ,[UserStatusId] 
  ,[UserLoginInfoId] 
  ,[HeadShotId] 
  ,[OrganizationId] 
  FROM [DecisionCriticalSuite].[dbo].[User] 
  GO 

来自 nhprof 的错误

ERROR:  
Invalid column name 'UserId'. 
Invalid column name 'UserId'. 
Invalid column name 'EntityId'. 
Invalid column name 'EntityId'. 
Invalid column name 'CreateDate'. 
Invalid column name 'ChangeDate'. 
Invalid column name 'ChangedBy'. 
Invalid column name 'Archived'. 
Invalid column name 'FileType'. 
Invalid column name 'UserId'.Could not execute query: SELECT documents0_.UserId as UserId1_, documents0_.EntityId as EntityId1_, documents0_.EntityId as EntityId49_0_, documents0_.CreateDate as CreateDate49_0_, documents0_.ChangeDate as ChangeDate49_0_, documents0_.ChangedBy as ChangedBy49_0_, documents0_.Archived as Archived49_0_, documents0_.Name as Name49_0_, documents0_.Description as Descript7_49_0_, documents0_.FileUrl as FileUrl49_0_, documents0_.Pages as Pages49_0_, documents0_.Size as Size49_0_, documents0_.FileType as FileType49_0_, documents0_.DocumentCategoryId as Documen12_49_0_, documents0_.UserId as UserId49_0_ FROM [Document] documents0_ WHERE           documents0_.UserId=@p0 

请您参考如下方法:

确保 nhibernate 查询的数据库与您在 sql management studio 中查询的数据库相同。