Getting SQL queries generated with Entity Framework Plus?

entity-framework-6 entity-framework-plus

Question

I am enjoying the features of Entity Framework Plus over Entity Framework 6 since a few hours, and especially its IncludeFilter.

With regular Entity Framework 6, I was able to simply call ToString() on an IQueryable to easily get the SELECT query that will be actually processed on DB Server.

But with EF+, when I apply an IncludeFilter, I only get :

 Z.EntityFramework.Plus.QueryIncludeFilterParentQueryable`1[MyRecord]

Because ToString() seems to not be overloaded the same way in EF+.

Is there a way to get SQL generated for "IncludeFilter" queries as well as for classical queries ?

I know I could get it on SQL server itself with the adequate profiling tools, but I would like to be able to do it on code side in EF.

1
1
5/10/2019 1:58:42 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Expert Answer

Is there a way to get SQL generated for "IncludeFilter" queries as well as for classical queries ?

No, there is currently no way.

It might come later but at this moment, the library doesn't offer this feature.

(I'm the owner)

EDIT: Answer comment

My main worry was to know if the generated queries are optimized

I would not call them optimized. They are generated by Entity Framework and nothing is really modified on our side.

  • IncludeFilter: Create one VERY big query like Include does in EF6
  • IncludeOptimized: Create multiple small queries like Include does in EF Core
2
5/13/2019 1:44:51 PM

Popular Answer

You can use the current context's log to track all requests performed under this instance

        context.Database.Log = s => Console.WriteLine(s);
AbuDawood

Related Questions

Entity framework migrations - generate sql script of current database model

I am trying to generate sql script that will create a database for me. So far I tried this:...Update-Database -Script -SourceMigration: $InitialDatabase Update-Database -Script -SourceMigration:0 ...But both of those are giving me scripts that are beggining from first migration to last. And there is no initial state of database, which should includ...
entity-framework migration
asked by ojek

Does LINQpad output generated SQL with Entity Framework 6 RTM?

When using a LINQpad data connection with an Entity Framework 6 DbContext derived object, I'm not getting anything in the SQL pane. I have no problems running queries or performing updates, just not seeing the generated SQL. According to the release notes: "...LINQpad now provides full SQL traces with EF 6.0 Beta 1 and later..." I did not use the ...
entity-framework-6 linqpad
asked by Jeff.

Entity Framework query ToString won't produce SQL query

Through my research I've discovered that, since at least EF 4.1, the .ToString() method on an EF query will return the SQL to be run. Indeed, this very frequently works for me, using Entity Framework 5 and 6....However, occasionally I call this method and get the runtime type of the query object. Here is my specific example:...Entity input = ...; I...
c# entity-framework entity-framework-5 entity-framework-6
asked by TheRubberDuck

Logging the SQL generated by LINQ to SQL in Entity Framework in .net

I am designing a testing framework that makes extensive use of SQL Sever Database. ...I am using Entity Framework 6... of .NET to felicitate it. I want to log the Underlying SQL query each time when I run a test case. I am using LINQ to SQL for querying Database....I am having a hard time logging the SQL. LINQ to SQL generates some uncooked SQL whi...
entity-framework-6 logging sql sql-server
asked by Madhur Maurya

Entity Framework Code-First: Generate SQL script with 'Update-Database' produces XML error while parsing

Our project uses Entity Framework 6.0 with .NET 4.5, FAT-Client with Code-First approach....We have about 20 migration-files (C# partial classes) generated automatically via the cmdlet ...Add-Migration... in the Visual Studio Package Manager Console, and applied successfully via ...Update-Database.......Now, our client has an integration database t...
c# ef-code-first ef-migrations entity-framework
asked by domin

Generate SQL script to Seed initial data with Entity Framework v6.1 Code First

When deploying an application that makes use of Entity Framework v6.1 Code First I use ...Update-Database -Script... to obtain a SQL statement I can execute against my database. How can I generate a similar script that will ...Seed... my database with the initial data? My Production server does not have Visual Studio installed nor do I want it inst...
deployment ef-code-first entity-framework-6 sql-server
asked by webworm

Entity Framework's auto generated class's code gets re generated every time model is updated

I am using ADO.Net Entity Data Model which connects to a SQL Server database to generate entity classes....I am creating partial classes for the generated classes with this attribute:...[MetadataType(typeof(Employee))] ...to put ...DataAnnotations... on the fields. So I remove all fields from generated class (....g.cs...) and move them to the othe...
asp.net-mvc c# entity-framework entity-framework-6 sql-server
asked by WAQ

Entity Framework 6 mapping a custom SQL query to an Entity

There are several ways to accomplish what you want to do, using either Entity Framework only or extra tools like ...Dapper...Entity Framework Only:...First you can use ...Linq... to extract the data, I'll look something like this:...var list = from s in Samples join l in SampleLocations on s.Id equals l.LocationId ...
asp.net-mvc c# entity-framework entity-framework-6
asked by Roy Sanchez

Entity Framework and Firebird DB Dialect 1 - not generating compatible sql

I am trying to setup a project with EF on top of a firebird DB but it is generating extra quotes that the Firebird db is rejecting....The db already exists and there is a matching record for this query there. Error is FbException: Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column 4 ....However if I remove the quotes it generate...
c# entity-framework entity-framework-6 firebird firebird2.5
asked by Paul Swetz

C# convert sql query into EF dbcontext linq to entities query

I have an sql server database and I use EF 6.0 to access it in my app....I have the following SQL Query I need to convert to dbcontext linq to entities query and have some damn hard time figure it out....This is the query:...select PA.Number, PA.Name, PR.* from MYDBNAME.dbo.Product PR join MYDBNAME.dbo.Order OD on PR.Id = OD.Id join MYDBNAME...
c# entity-framework-6 linq linq-to-entities sql
asked by user2818430

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow