In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-22 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/01 Report--
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!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.