How to use the Entity Framework Core plug-in ToSql
This article mainly introduces how to use the Entity Framework Core plug-in ToSql, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.
Background
When using EntityFrameworkCore for development, it is difficult to find a query SQL statement without using Logger. At the same time, some developers develop Pomelo.EntityFrameworkCore.Extensions.ToSql because they do not know which Linq of EF Core can be Translate into SQL, and which can not lead to full table query. Developers can use this plug-in for unit testing of queries, or for simple tests of query statements on EF Core.
Use
First, introduce Pomelo.EntityFrameworkCore.Extensions.ToSql 2.0.0-preview3-10000 into the project.
Reference the namespace Microsoft.EntityFrameworkCore in the class where you want to output the SQL statement, and add .ToSql () where you want to output the SQL statement.
Var MySqlContext = new MySqlContext (); Console.WriteLine (MySqlContext.Models .Where (x = > x.Title.Contains ("Pomelo")) .Where (x = > new [] {2,3,5,7,11} .conformance (x.Count)) .Where (x = > x.Title.Skip (3) .Take (4). ToString () = "Hello") .ToSQL ())
Execute .ToUnevaluated () at the place where you want to output Linq statements that failed to be translated to return the Linq code that failed to execute:
Var MySqlContext = new MySqlContext (); var unevaluated = MySqlContext.Models .Where (x = > x.Title.Contains ("Pomelo")) .Where (x = > new [] {2,3,5,7,11} .conformance (x.Count)) .Where (x = > x.Title.Skip (3) .Take (4). ToString () = "Hello") .ToUnevaluated (); foreach (var x in unevaluated) {Console.WriteLine (x);}
Running result
By calling .ToSql () and .ToUnevaluated () to see the translation results of success and failure, the successful SQL statements and failed Linq statements are clear in the above figure.
Thank you for reading this article carefully. I hope the article "how to use the Entity Framework Core plug-in ToSql" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!
