The Entity Framework DbEntityEntry object lets you do all sorts of things you probably didn't think were possible, including getting the latest data from the database (without losing your current data) and invoking the .NET Framework validation subsystem.
If you're not using the Entity Framework DbCollectionEntry object when working with an entity class's related objects, then your application is running too slow. Using DbCollectionEntry lets you asynchronously retrieve related objects and get only the objects you want.
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.
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
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
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.
A significant disruption of Microsoft's Azure cloud services has affected a large number of customers in Europe and India, and it's really trying the patience of developers using Visual Studio Team Services, with only partial use of services back online as of Friday afternoon.
- By Michael Domingo
- 09/09/2016
As you work with other developers (and seek advice from experts) you need to make sure you're discussing what matters rather than arguing about terminology.
Create the best object for moving data from your Controller to your View.
There are so many ways to integrate an SSRS report into your page that the biggest problem you'll face is deciding which one to use. Peter runs through all the solutions he can think of, including those cases where you want to download the report as a file.
WinDocks is now available for .NET developers looking for a smoother solution for spinning up Windows Server 2012-based Docker containers in the AWS cloud.
- By Michael Domingo
- 06/03/2016
Microsoft's venerable RDBMS gets a major update, with a developer-enabled version that unclutters the enterprise database solution development process.
- By Michael Domingo
- 05/03/2016
A new tool that ingests every piece of Application Insights and turns it into reportable information is now getting its public preview. It's also got a name.
- By Michael Domingo
- 04/05/2016
Microsoft offered a preview of Visual Studio '15' at Build last week. And whileit's just not quite ready for prime time, it's got an impressive number of changes with practically every tool in it that demand developer attention.
- By Michael Domingo
- 04/05/2016
It's limited what VSDE member can do with it. Also: SQL Server 2016, when released later this year, will also be free.
- By Michael Domingo
- 04/01/2016
Save 35 percent on developer titles when purchasing books or downloading e-books directly from the Microsoft Press Store. Sale ends March 31.
- By Michael Domingo
- 03/17/2016
Microsoft R and R Server features are accessible almost directly through the Visual Studio IDE, with the new R Tools for Visual Studio plugin.
- By Michael Domingo
- 03/10/2016
Microsoft Build doesn't have the build up of, say, a major release of Visual Studio, to attract attendees, so why does it sell out? It's all about networking.
- By Michael Domingo
- 03/09/2016
Microsoft's Scott Guthrie said that the company's RDBMS could be running on the Linux platform some time in 2017. He plans to preview a new SQL Server Stretch Database service at a New York event this week.