mysql – 奇怪的NHibernate QueryOver语法错误

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql – 奇怪的NHibernate QueryOver语法错误，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5432字，纯文字阅读大概需要8分钟。

内容图文

//This code works fine.
UserProfile profile = session.QueryOver<UserProfile>().Where(userProfile => userProfile.UserId == user).List().FirstOrDefault();

//This code throws an invalid Syntax Error
IList<Character> characters = session.QueryOver<Character>().Where(character => character.UserId == user).List<Character>();

使用NHibernate QueryOver时,我遇到了上述代码的问题.数据库具有与User表关系设置的两个项目.它们设置相同,并且两个Map类都设置为相同.

    public class CharacterMap : ClassMap<Character>
{
    public CharacterMap()
    {
        Id(x => x.Id).Column("id");
        Map(x => x.Name).Column("name");
        Map(x => x.Class).Column("class");
        Map(x => x.Level).Column("level");
        Map(x => x.Sex).Column("sex");
        Map(x => x.Stats).Column("stats"); //Varchar 2048
        Map(x => x.Position).Column("position"); //Varchar 1024

        References(x => x.UserId).Column("user_id");
        Table("character");
    }
}

和

    public class UserProfileMap : ClassMap<UserProfile>
{
    public UserProfileMap()
    {
        Id(x => x.Id).Column("id");
        Map(x => x.CharacterSlots).Column("character_slots");
        References(x => x.UserId).Column("user_id");
        Table("user_profile");
    }
}

和User是根据此映射构建的类.

public class UserMap : ClassMap<User>
{
    public UserMap()
    {
        Id(x => x.Id).Column("id");
        Map(x => x.Username).Column("username");
        Map(x => x.Password).Column("password");
        Map(x => x.Salt).Column("salt");
        Map(x => x.Email).Column("email_address");
        Map(x => x.Algorithm).Column("algorithm");
        Map(x => x.Created).Column("created_at");
        Map(x => x.Updated).Column("updated_at");
        Table("user");
    }
}

实体是：

public class UserProfile
{
    public virtual int Id { get; set; }
    public virtual User UserId { get; set; }
    public virtual int CharacterSlots { get; set; }
}

public class User
{
    public virtual int Id { get; set; }
    public virtual string Username { get; set; }
    public virtual string Password { get; set; }
    public virtual string Salt { get; set; }
    public virtual string Email { get; set; }
    public virtual string Algorithm { get; set; }
    public virtual DateTime Created { get; set; }
    public virtual DateTime Updated { get; set; }
}

public class Character
{
    public virtual int Id { get; set; }
    public virtual User UserId { get; set; }
    public virtual string Name { get; set; }
    public virtual string Class { get; set; }
    public virtual string Sex { get; set; }
    public virtual int? Level { get; set; }
    public virtual string Stats { get; set; }
    public virtual string Position { get; set; }


    public virtual CharacterDetails BuildCharacterListItem()
    {
        return new CharacterDetails()
                    {
                        Id = Id,
                        Class = Class,
                        Name = Name,
                        Level = Level,
                        Sex = Sex
                    };
    }
}

问题是当我尝试使用User类作为比较从表中获取“Characters”列表时,我得到一个语法错误但是你可以看到第一个查询返回结果很好而且两者几乎相同.

有谁知道为什么会发生这种情况？我无法理解我的生活.

我收到的错误是：

        Error: could not execute query
    [ SELECT this_.id as id0_0_, this_.name as name0_0_, this_.class as
     class0_0_, this_.level as level0_0_, this_.sex as sex0_0_, this_.stats 
    as stats0_0_, this_.position as position0_0_, this_.user_id as 
    user8_0_0_ FROM character this_ WHERE this_.user_id = ?p0 ]
      Name:cp0 - Value:PerilousServer.Data.NHibernate.User
    [SQL: SELECT this_.id as id0_0_, this_.name as name0_0_, this_.class 
    as class0_0_, this_.level as level0_0_, this_.sex as sex0_0_, this_.stats 
as stats0_0_, this_.position as position0_0_, this_.user_id as user8_0_0_ 
FROM character this_ WHERE this_.user_id = ?p0]

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character this_ WHERE this_.user_id = 11' at line 1

如果有帮助,最后这里是整个Session / transaction.即使我能够使用相同的QueryOver语法获取UserProfile,所以一切都恢复正常,直到我点击QueryOver().

   try
    {
        using (var session = NHibernateHelper.OpenSession())
        {
            using (var transaction = session.BeginTransaction())
            {
                //Get userData from logged in connections for verification later..
                var userData = Server.Instance.ConnectedUsers[peerID];
                var user = session.QueryOver<User>().Where(u => u.Id == userID).List().FirstOrDefault();

                if (user != null)
                {
                    UserProfile profile = session.QueryOver<UserProfile>().Where(userProfile => userProfile.UserId == user).List().FirstOrDefault();
                    if (profile != null)
                    {
                        //Check to see if peerID is actually connected.
                        if (userData != null && userData.ClientData<UserData>().UserId == userID )
                        {
                            Console.Write("Found user: {0} and matching to character.", profile.UserId.Id);
                            IList<Character> characters = session.QueryOver<Character>().Where(character => character.UserId == user).List<Character>();

                            List<CharacterDetails> characterList = new List<CharacterDetails>();

                            foreach (var character in characters)
                            {
                                characterList.Add(character.BuildCharacterListItem());
                            }

                            response = new Message(MessageType.Response, MessageCode.Login, (byte)LoginCode.CharacterList);
                            response.AddParameter(MessageParameterCode.CharacterSlots, profile.CharacterSlots);
                            response.AddParameter(MessageParameterCode.CharacterList, characterList);

                            client.Send(response);
                            transaction.Commit();
                        }
                        else
                        {
                            //Send message saying the account was trying to access someone elses information.
                            client.OnLog("User ID's did not match. PeerID is incorrect.");
                        }
                    }
                    else
                    {
                        //Send message that profile was not found.
                        client.OnLog("User Profile was not found.");
                    }
                }
                else
                {
                    //Send message saying there was no user with that ID. NULL
                    client.OnLog("UserID was null.");
                }
            }
        }
    }
    catch (Exception e)
    {
        client.OnError(e.Message);
        client.OnError(e.InnerException.Message);

        //Send message we recieved an error.
    }
}

解决方法:

显然这是因为字符是mySql中的保留字.有关更多信息,请参阅this问题.

内容总结

以上是互联网集市为您收集整理的mysql – 奇怪的NHibernate QueryOver语法错误全部内容，希望文章能够帮你解决mysql – 奇怪的NHibernate QueryOver语法错误所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---