The public purpose of this repository is to set an example. Should you need to, you can clear the cache by killing the process via the option on the query menu (Ctrl+Shift+F5). This is my personal collection of LinqPad queries that I use to work out in C (and, soon, F). Press Ctrl+, to bring up the search dialog, click Search Samples and search for 'Caching'. It can be downloaded at This page compares LINQPad with our Visual Studio addin, LINQ Insight, that allows executing LINQ queries at design. It is a standalone application that allows you to execute LINQ queries or other C/VB statements. There are more examples in LINQPad's built-in tutorial and reference. LINQPad is a popular tool for testing LINQ queries. LocalCustomers.Where (c => c.Name = "Mary").Dump() You can also cache a subset of the data: var localCustomers = Customers.Where (c => c.Country = "US").Cache() LINQPad does not recognize installed dotnet 6 version. LinqPad in linux with wine - nuget issue. When you re-execute the query, LINQPad will not fetch anything from the database because customers will have been cached in memory from the first run. Welcome to the LINQPad forum Announcement Closed 2.1K views 11 comments.
It is used to interactively query SQL databases (among other data sources such as OData or WCF Data Services) using LINQ, as well as interactively writing C code without the need for an IDE.
Here's how to use the Cache extension method: var customers = Customers.Cache() // Slow only on the first executionĬustomers.Where (c => c.Name = "Joe").Dump() Īfter running the query, change the second line to something like this: customers.Where (c => c.Name = "Mary").Dump() description (en) LINQPad - is a software utility targeted at. The Cache extension method works on IEnumerable whereas the Util.Cache method works on any type. LINQPad is not just for LINQ queries, but any C/F/VB expression, statement block or program.Put an end to those hundreds of Visual Studio Console projects cluttering your source folder and join the revolution of LINQPad scripters and incremental developers. LINQPad provides a Cache extension method and a Util.Cache method for caching data in memory between runs.