c# - Linq union two tables where on has an extra column -


i using union combine 2 tables audit , message. both have same column names except audit has column called deletedate. try use union merge both table if deletedate not exist, sets deletedate method null. commented out trying work. when uncomment code, error. there work around? here code 

    var audit = in _audit.getall()                        .where(a => a.pint == pint && a.createdate < startdate && (enddate == null || enddate > a.createdate))                        select new                        {                            a.mint,                            a.mid,                            a.desc,                            a.pstring,                            a.ptype,                            a.mtype,                            a.createdate,                            //    a.deletedate,                            a.pint                        };      var message = in _message.getall()            .where(a => a.partnerint == partnerint && a.createdate < startdate && (enddate == null || enddate > a.createdate))                   select new                   {                       a.mint,                       a.mid,                       a.desc,                       a.pstring,                       a.ptype,                       a.mtype,                       a.cdate,                       a.pint                   };      var test = in audit.union(message)                select new auditmessagesgroup                {                    mint = a.int,                    mid = a.id,                    desc = a.desc,                    pstring = a.pstring,                    ptype = a.payloadtype,                    messagetype = a.mtype,                    createdate = a.createdate,          //          deletedate = a.deletedate != null ? a.deletedate : null,                    pint = a.pint                 };

here error

    error   cs1929  'iqueryable<<anonymous type: int mint, guid   mid, string desc, string pstring, string ptype,   mtypes mtype, datetime createdate, datetime deletedate, int?   pint>>' not contain definition 'union' , best   extension method overload 'parallelenumerable.union<<anonymous type: int   mint, guid mid, string desc, string pstring, string   ptype, mtypes mtype, datetime createdate, int? pint>>  (parallelquery<<anonymous type: int mint, guid mid, string   desc, string pstring, string ptype, mtypes   mtype, datetime createdate, int? pint>>, ienumerable<<anonymous   type: int mint, guid mid, string desc, string   pstring, string ptype, mtypes mtype, datetime   createdate, int? pint>>)' requires receiver of type   'parallelquery<<anonymous type: int mint, guid mid, string   desc, string pstring, string ptype, mtypes   mtype, datetime createdate, int? pint>>'

no can't. basic criteria on union column count must match b/w tables. can generate dummy column though bypass. like

considering a.deletedate datetime in audit change message be

var message = in _message.getall()        .where(a => a.partnerint == partnerint && a.createdate < startdate && (enddate == null || enddate > a.createdate))               select new               {                   a.mint,                   a.mid,                   a.desc,                   a.pstring,                   a.ptype,                   a.mtype,                   a.cdate,                   datetime.now, // dummy column                   a.pint               };

then can perform union


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more