Entity Framework 7 Union Query error

Entity Framework query ToString won't produce SQL query

If you do not need the SQL BEFORE it is executed against the DB you can do the following:...dbContext.Database.Log = s => Debug.WriteLine(s); ...This would print the SQL (and some additional data) to the debug output.... See the following link for details: ...http://msdn.microsoft.com/de-DE/data/dn469464...Also check, as martin_costello suggested, ...

Entity Framework Core 2.0: Error when enumerating over query with group

This seems to be a bug in EF Core 2.0 which got addressed in this issue (Contains workaround):...https://github.com/aspnet/EntityFrameworkCore/issues/9551...You can get the testfeed 2.0.3 here (Contains fix):...https://github.com/aspnet/Announcements/issues/274

Include after Union method not working (Entity Framework Core 2)

You are accessing the IQueryable out of the context of the MyDbContext object. There is no db connection at that time. Make sure you do all db access withing the context of the MyDbContext (using scope):... public IEnumarable<User> GetItems() { IEnumarable<User> resultingList; using (var context = new MyDbContext()) { IQueryable<Us...

Entity Framework Core Code First changing added entities values before save causes identity insert error

The documentation of ...ToObject... method states:...Creates an instance of the entity type and sets all its properties using the values from this object....In other words, the method creates a ...new... entity instance and populates it with the current values of the tracked entity....Note that at the time you add entity to the context, EF generate...

Unable to get complete SQL text from Entity Framework Core queries containing Union

Are you sure that you get tbe complete SQL with the extension method ToSql? This line:... var sql = modelVisitor.Queries.First().ToString(); ...Can a Union have two queries?...Try first to loop through queries and log them to the console forexample....foreach (var query in modelVisitor.Queries) Console.WriteLine(query); ...That will call toStrin...

Does Entity Framework Core support Union?

You try to have ...Union... of different anonymous types, please use same types or don't use anonymous types at all, like in my snippet...var query = _context.Brand.Select(x => x.Brandid) .Union(_context.Factory.Select(x => x.Factorycode)) .Union(_context.Brandfactory.Select(x => x.Factoryid))...

Avoid Query Client Evaluation error on a query with method definition inside entity class

Finally, the solution was almost there, as also @StriplingWarrior said....Due to limitations in the C# compiler, such that it can't create expression trees for this code, the solution is to factory the conversion code into methods and then call those in ...HasConversion.......protected override void OnModelCreating(ModelBuilder modelBuilder) { ...

How to execute a raw union SQL query on several tables with Entity Framework Core

I did not find a way to query two tables. I tried to create a DbSet that consists of attributes in both tables but this didn't work too....Not sure what exactly "didn't work", but this is the way to go. But instead of creating ...DbSet... of the class containing the common attributes, thus telling EF to treat is an ...entity..., create ...DbQuery..

Is there a way to make the faster ordered SQL TOP 1 query as Entity Framework query?

For this query:...select top (1) m.* from movies m where m.Distributor = 'any' order by m.IMDB_Rating desc; ...You want an index on ...movies(Distributor, IMDB_Rating desc).......I cannot speak to why the second version would be faster.

Linq inner query in join with entity framework, query error

You are left join results from a inner join. I am thinking that is missed in your c# code. But that is not the case for exception....you may try like this....var result = from ca in _dbcontext.CustomerAircrafts //// here join the inner join join pta in (from f in _dbcontext.AircraftPrices join pt in _dbcontext.PricingTemplate on ap.Pri...