“在 Web 服务中创建 SessionFactory”NHibernate 时使用了无效或不完整的配置
本文关键字:无效 配置 服务 Web 创建 NHibernate SessionFactory | 更新日期: 2023-09-27 18:32:54
正如标题所说,我收到一个错误:"创建会话工厂时使用了无效或不完整的配置。查看 PotentialReasons 集合和 InnerException 以获取更多详细信息。
我将从代码开始。
数据库:
用户表:
CREATE TABLE [dbo].[User] (
[Id] UNIQUEIDENTIFIER NOT NULL,
[Username] NVARCHAR (50) NULL,
[PasswordHash] CHAR (64) NOT NULL,
[Salt] CHAR (64) NOT NULL,
[Role] UNIQUEIDENTIFIER NOT NULL,
[Token] NVARCHAR (50) NOT NULL,
[TokenStamp] DATETIME NULL,
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [FK_User_Role] FOREIGN KEY ([Role]) REFERENCES [dbo].[Role] ([Id])
);
角色表:
CREATE TABLE [dbo].[Role] (
[Id] UNIQUEIDENTIFIER NOT NULL,
[Name] NVARCHAR (50) NULL,
CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([Id] ASC)
);
用户类:
using System;
namespace Models
{
public class User : EntityBase
{
public virtual string Username { get; set; }
public virtual string PasswordHash { get; set; }
public virtual string Salt { get; set; }
public virtual Guid Role { get; set; }
public virtual string Token { get; set; }
public virtual DateTime TokenStamp { get; set; }
}
}
角色类:
namespace Models
{
public class Role : EntityBase
{
public virtual string Name { get; set; }
}
}
实体库:
using System;
namespace Models
{
public class EntityBase
{
public virtual Guid Id { get; set; }
}
}
用户地图:
using FluentNHibernate.Mapping;
using Models;
namespace NHibernate.Mapping
{
public class UserMap : ClassMap<User>
{
public UserMap()
{
Table("User");
Id(x => x.Id).GeneratedBy.GuidComb();
LazyLoad();
References(x => x.Role).Column("Role");
Map(x => x.Username).Column("Username");
Map(x => x.PasswordHash).Column("PasswordHash").Not.Nullable();
Map(x => x.Salt).Column("Salt").Not.Nullable();
Map(x => x.Token).Column("Token").Not.Nullable();
Map(x => x.TokenStamp).Column("TokenStamp");
}
}
}
角色映射:
using FluentNHibernate.Mapping;
using Models;
namespace NHibernate.Mapping
{
public class RoleMap : ClassMap<Role>
{
public RoleMap()
{
Table("Role");
Id(x => x.Id).GeneratedBy.GuidComb();
LazyLoad();
Map(x => x.Name).Column("Name");
}
}
}
自定义外键约定:
using FluentNHibernate;
using FluentNHibernate.Conventions;
namespace NHibernate.Conventions
{
public class CustomForeignKeyConvention : ForeignKeyConvention
{
protected override string GetKeyName(Member property, System.Type type)
{
if (property == null)
{
return type.Name;
}
return property.Name;
}
}
}
会话工厂:
using FluentNHibernate.Cfg;
using FluentNHibernate.Cfg.Db;
using NHibernate.Conventions;
namespace NHibernate
{
public static class SessionFactory
{
private static ISessionFactory _sessionFactory;
public static ISessionFactory Instance
{
get
{
if (_sessionFactory == null)
{
_sessionFactory = CreateSessionFactory();
}
return _sessionFactory;
}
}
private static ISessionFactory CreateSessionFactory()
{
return Fluently.Configure()
.Database(MsSqlConfiguration.MsSql2012
.ConnectionString(c => c.FromConnectionStringWithKey("DatabaseConnectionString")))
.Mappings(m =>
{
m.FluentMappings.Conventions.AddFromAssemblyOf<CustomForeignKeyConvention>();
m.FluentMappings.AddFromAssemblyOf<Models.EntityBase>();
})
.BuildSessionFactory();
}
}
}
网络服务.cs
using System.Linq;
using System.Net;
using System.Web.Services;
using NHibernate;
using Models;
[WebService(Namespace = "http://LambdAlarm.com/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class LambdAlarmWebService : WebService
{
[WebMethod]
public HttpStatusCode Login(string username, string password)
{
var factory = SessionFactory.Instance;
var session = factory.OpenSession();
var result = session.QueryOver<User>().List<User>();
var login = result.Where(u => u.Username == username).Where(p => p.PasswordHash == password);
return HttpStatusCode.NotFound;
}
}
所以是的...这不是一件容易的事。我认为数据库中的外键关系与用户和角色表有关。角色列应引用角色表中的 ID。
请帮忙!
问题是References()
旨在引用另一个实体,而不是一个类型。如果要使用类型,则应使用 Map(x => x.Role)
而不是References(x => x.Role)
将User
更改为:
public class User : EntityBase
{
public virtual string Username { get; set; }
public virtual string PasswordHash { get; set; }
public virtual string Salt { get; set; }
public virtual Role Role { get; set; } //CHANGED HERE
public virtual string Token { get; set; }
public virtual DateTime TokenStamp { get; set; }
}
您的UserMap
:
public UserMap()
{
Table("User");
Id(x => x.Id).GeneratedBy.GuidComb();
LazyLoad();
References(x => x.Role).Column("Role");
Map(x => x.Username).Column("Username");
Map(x => x.PasswordHash).Column("PasswordHash").Not.Nullable();
Map(x => x.Salt).Column("Salt").Not.Nullable();
Map(x => x.Token).Column("Token").Not.Nullable();
Map(x => x.TokenStamp).Column("TokenStamp");
}
此外,在使用 Fluent NHibernate 映射时,没有理由指定列名。默认情况下,它只会使用您的属性名称,因此类似于 Map(x => x.Name).Column("Name").Not.Nullable()
的内容与 Map(x => x.Name).Not.Nullable()
其他一些建议:
为映射创建一个基类以使其更容易:
public abstract class ClassMapBase<T> : ClassMap<T> where T: EntityBase
{
protected ClassMapBase()
{
Id(x => x.Id).Not.Nullable().GeneratedBy.GuidComb();
LazyLoad();
}
}
另外,我很惊讶NHibernate没有抱怨你Id
EntityBase
有一个公共二传手。它应设置为"受保护"或"专用"。也无需指定表名称,除非您希望它与实体名称不同
虽然有一个正确的答案,但我只会让其他人可能觉得有用的另一个解决方案。当数据库无法访问应用程序时,会导致此错误。所以:
- 签入
services.exe
并查看您的 SQL Server 是否正在运行 - 或者简单的解决方案,检查连接字符串是否指向数据库。
如果其他人发现此类错误,请检查您的实体中是否存在虚拟关键字。例如:
public class Word : IEntity
{
public virtual int WordID { get; set; }
public virtual string WordText { get; set; }
public virtual string Pronunciation { get; set; }
}