Complex queries can be solved with a combination of simpler LINQ queries, anonymous objects and the Group/By/Into clauses. Using Group/By/Into will also give you the best possible performance for those complex queries.
Here's a trick to have Marten automatically deserialize JSON data only when you want it to.
- By Jason Roberts
- 02/16/2017
When you want to find all the objects that are missing a corresponding object, then you need the LINQ equivalent of an outer join. Here, step by painful step, is how to build that query.
If you decide on using an Enum with enumerated values in your Entity Framework class, here are the tools you'll need to make it work. But an enumerated value shouldn't be your first choice.
Here are two ways to save some typing when defining anonymous objects. One only works in Visual Basic, though.
Find the patterns in your data sets using these Clustering.R script tricks.
- By James McCaffrey
- 02/01/2017
Marten is PostgreSQL-based, so take advantage of relational features where it makes sense. Here's an example.
- By Jason Roberts
- 01/24/2017
Peter starts off with a perfectly good solution to a problem but then complicates the problem . . . and ends up moving to a different design pattern. While on that journey he has some best practices around designing Data Transfer Objects.
You probably use ToList to convert your LINQ results into Lists. It's almost as easy to convert any collection into a Dictionary whose items you can retrieve by key.
Sometimes life is like playing Whack-a-Mole: You write some code that solves a problem, and then someone comes along and makes the problem harder. Here's how to continuously integrate new solutions without having to rewrite your old solutions (much).
Whether you're building an application database or generating data access code, we've got a round-up of tools to make the job easier.
- By Terrence Dorsey
- 01/04/2017
You can turn on logging for your Entity Framework code with a single line. Configuring it to write to a file takes only a little bit more effort.
There's more (and some less) in Entity Framework Core compared to Entity Framework 6, at least in version 1.0. While you can move to Entity Framework Core now, it might be too early for you.
Saving and retrieving data is a fundamental part of all but the simplest of applications. In this article, Nick walks through getting started using Entity Framework with SQLite to persist application data.
- By Nick Randolph
- 12/15/2016
Document databases are a form of NoSQL database that may store all of the information for a given object in a single instance in the database.
- By Jason Roberts
- 12/12/2016