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
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
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
Every once in a while you'll need to use the LINQ Join to get the data you want.
I predict you'll find this logistic regression example with R to be helpful for gleaning useful information from common binary classification problems.
- By James McCaffrey
If you're using Skip and Take in LINQ to page through your data, a tweak to your syntax can cut your response time by as much as 10 percent as you page through your data.
- By Michael Domingo
Sometimes you want child objects retrieved with the parent object, and sometimes you don't. What you NEVER want is to retrieve child objects accidentally. Here's Peter's advice on how to get the best performance when loading child objects.
The ability to embrace U-SQL jobs via authoring, scripting, extensibility via the VSCode environment and using C# is the key to this tooling preview.
- By Michael Domingo
One highlight of this roll-up release is the addition of row-level security and dynamic data masking, which were only available in the Enterprise version, are now in Standard, Express, and other versions.
Polybase, Query Store, dynamic data masking, row-level security, and temporal data JSON support -- just some of the new features that veteran SQL Server Live! presenter Leonard Lobel covers in this exclusive Q&A with Lafe Low.
There are two attributes you can put on your entity class properties: one is a convenience, the other is essential, and both are required when the primary key for a table consists of two columns.