“无效的对象名称'dbo.成员资格“,尝试添加新用户时

本文关键字:添加 新用户 用户 对象 无效 dbo 成员 | 更新日期: 2023-09-27 18:36:23

我在最近一天或两天做了一些事情来破坏我的应用程序。

我有一种方法可以使用成员资格提供程序在成员资格数据库中创建新用户。

例如

 public void Create(Consumer consumer)
    {
        MembershipCreateStatus status;
        if (consumer.UserId == Guid.Empty)
        {
            consumer.UserId = Guid.NewGuid();
        }
        if (consumer.ConsumerId == Guid.Empty)
        {
            consumer.ConsumerId = Guid.NewGuid();
        }
        try
        {
            var membershipUser = Membership.CreateUser(consumer.UserName, consumer.Password, consumer.Email, null, null, consumer.IsApproved, consumer.UserId, out status);
....
}

内部例外是

{"无效的对象名称'dbo.会员资格'。

堆栈跟踪是

at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommand(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Objects.ObjectQuery 1.GetResults(Nullable 1 forMergeOption) at System.Data.Objects.ObjectQuery 1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable 1 个来源) at System.Data.Objects.ELinq.ObjectQueryProvider.b__1[TResult](IEnumerable 1 sequence) at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable 1 query, Expression queryRoot) at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](表达式表达式) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable'1 source) at System.Web.Providers.QueryHelper.GetMember(MemberEntities ctx, String applicationName, Guid userId) at System.Web.Providers.DefaultMembershipProvider.Membership_CreateUser(String applicationName, String userName, String password, String salt, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, DateTime&createDate, Boolean uniqueEmail, Int32 passwordFormat, Object& providerUserKey) at System.Web.Providers.DefaultMemberProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MemberCreateStatus& status) at System.Web.Security.Member.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MemberCreateStatus& status) at Plenfy.Api.Models.ConsumerRepository.Create(Consumer consumer) in c:''@Code''Customers''Api''Repository''ConsumerRepository.cs:line 121

我不知道如何解决问题。数据库和连接字符串看起来不错,我可以使用 EF 连接到它。

谁能建议如何深入了解这一点?

“无效的对象名称'dbo.成员资格“,尝试添加新用户时

try to use 
MembershipCreateStatus status;
        if (consumer.UserId == Guid.Empty)
        {
            consumer.UserId = Guid.NewGuid();
        }
        if (consumer.ConsumerId == Guid.Empty)
        {
            consumer.ConsumerId = Guid.NewGuid();
        }
        try
        {
            var membershipUser = System.Web.Security.Membership.CreateUser(consumer.UserName, consumer.Password, consumer.Email, null, null, consumer.IsApproved, consumer.UserId, out status);
        }