ServiceStack Ormlite-加入子类 [英] ServiceStack Ormlite - Joins on child classes

问题描述

我正在使用最新的ServiceStack Ormlite(v4.0.23)，它提供了对多列连接的新连接支持.

I'm using the latest ServiceStack Ormlite (v4.0.23), which provides new join support for joining on multiple columns.

我的实体都继承自BaseEntity:

My entities all inherit from a BaseEntity:

public class BaseEntity : IBaseEntity
{
  [AutoIncrement]
  [PrimaryKey]
  public long Id { get; set; }

  public DateTime Created { get; set; }

  public DateTime Updated { get; set; }

  public DateTime? Deleted { get; set; }

  public bool IsDeleted { get; set; }
}

说我有2个实体UserEntity和AnswerEntity，它们从此基类继承. 在v4.0.19中使用JoinSqlBuilder时，我可以使用类似以下内容的方法加入这些对象:

Say I have 2 entities, UserEntity and AnswerEntity, which inherit from this base class. When using the JoinSqlBuilder in v4.0.19 I could join these using something like this:

var joinBuilder = new JoinSqlBuilder<AnswerEntity, UserEntity>();

joinBuilder = joinBuilder.Join<AnswerEntity, UserEntity>(
  l => l.UserId,
  r => r.Id,
  x => new { x.Id, x.AnswerValue, x.QuestionId, x.Created, x.Updated, x.Deleted, x.IsDeleted },
  null,
  lx => lx.IsDeleted == false,
  rx => rx.IsDeleted == false);

更新后，出现错误:

MySql.Data.MySqlClient.MySqlException:未知列'BaseEntity.IsDeleted' 在"where子句"中 MySql.Data.MySqlClient.MySqlStream.ReadPacket()在 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& Row， Int64& insertId)...

MySql.Data.MySqlClient.MySqlException : Unknown column 'BaseEntity.IsDeleted' in 'where clause' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)...

使用新的联接支持，我得到相同的错误:

Using the new join support, I get the same error:

expression.Join<AnswerEntity, UserEntity>((l, r) => l.UserId == r.Id);
expression.Where<AnswerEntity>(x => x.IsDeleted == false);

推荐答案

现在应在此提交可从v4.0.23 + 版本中获得>目前在MyGet上可用.如果您已经安装了MyGet中的现有 v4.0.23 软件包，则需要先将其卸载才能拉下更新的软件包.

Should now be resolved in this commit that's available from v4.0.23+ of ServiceStack that's currently available on MyGet. If you have existing v4.0.23 packages from MyGet installed it will need to be uninstalled first to be able to pull down the updated packages.

这篇关于ServiceStack Ormlite-加入子类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！