c# - 带有自定义数据字段的 PetaPoco 多表连接

Question

我使用 PetaPoco.Compiled 6.0.441... 我想从两个具有内部连接的表中选择数据...

总是给我错误信息

System.InvalidCastException：对象必须实现 IConvertible。

请。帮我 ...

代码如下..

 [TableName("S_SEQ_LOG")]
    class S_SEQ_LOG
    {

        public string gSeqLogId { get; set; }

        public string iYear { get; set; }
        public string iMonth { get; set; }
        public string iDay { get; set; }
        public string iCurrentVal { get; set; }

        public string vTableNm { get; set; }

         [Ignore]
        public S_SEQ_RULE ssr { get; set; }
    }
    [TableName("S_SEQ_RULE")]
    class S_SEQ_RULE
    {

        public string vTableNm { get; set; }
        public string vRule { get; set; }
        public string vPrefix { get; set; }
        public string iLength { get; set; }
        public string iCurrentVal { get; set; }

    }
 var db = DbManager.Create("SqlServer");

            var posts = db.Fetch<S_SEQ_LOG, S_SEQ_RULE, S_SEQ_LOG>(
                (a, b) =>
                      { a.ssr = b; return a; }
                 ,
                        @"SELECT A.*,B.*
                        FROM S_SEQ_LOG  A INNER JOIN S_SEQ_RULE B ON
        A.vTableNm=B.vTableNm
                        ");

标签： c#petapoco