Union with different dataTypes Linq-to-entities

0

I'm trying to return a grid! with headers and values below. I'm trying to do this!

void Main()
{
    var ctx = dbContext;
    (from tQuestions in ctx.Questions
        select new 
        {
            a1_1 = (Object)tQuestions.HeaderCreationDate //varchar(max)   (sometning like "Creation Date")
        }
    ).Union<Object>(from tAnswers in ctx.Answers
        select new{
        a1_1 = (Object)tAnswers.CreationDate //DateTime (something like "2018-05-24 00:00:00.000")
        }
    ).Dump();
}

And I have: "Conversion failed when converting date and / or time from character string."

    
asked by anonymous 24.05.2018 / 18:28

0 answers