Leveraging Raw SQL in Entity Framework Core

Thu, 12 Apr 2018 12:30:00 GMT

The ability to use SQL with Entity Framework Core has always been a cool feature. There's a new feature in Entity Framework Core that opens the door for whole new set of SQL-related functionality.

High Performance Object-Oriented Data Access with Dapper

Thu, 22 Mar 2018 15:04:00 GMT

Entity Framework is fabulous ... but it does impose some overhead. If you like working with data in an O-O kind of way but feel the "need for speed," then you should be looking at Dapper.

Supporting Developers with JSON Schema

Wed, 28 Feb 2018 13:16:00 GMT

If you're building services it's critical that you support the developers who will create and read your service's messages. JSON Schema lets you support the three principles of good message design in a way that supports developers.

Managing and Enforcing Message Formats for Services

Tue, 27 Feb 2018 15:54:00 GMT

You can dramatically simplify life for developers creating services and their consumers by following three rules for designing messages and then enforcing your message formats with JSON Schema.

Designing Service Messages for Optimal Performance

Thu, 22 Feb 2018 12:22:00 GMT

If you're building services, then getting your message formats right can be the difference between success and failure. Here's an example of what can go wrong and how it could be fixed.

Validating JSON with JSON Schema

Tue, 13 Feb 2018 14:23:00 GMT

Once you've created a JSON Schema that describes a JSON document, you can use it both in Visual Studio -- to provide guidance when creating JSON documents -- and in your code to validate the messages you're receiving.

Changing the Way You Test with Live Unit Testing

Wed, 07 Feb 2018 11:50:00 GMT

Peter tries out Visual Studio Enterprise 2017's Live Unit Testing and has what might be a life-changing experience.

Defining JSON Messages with JSON Schema

Thu, 25 Jan 2018 12:00:00 GMT

If you're building a RESTful Web service, you can provide both guidance and control around the JSON messages your service works with by replacing documentation with JSON Schemas.

Architecting Services for Flexibility and Growth

Thu, 18 Jan 2018 13:06:00 GMT

The simplest way to ensure that the API your services expose to your consumers is to not let consumers access your services -- at least, not directly.

Architecting Services with Design Patterns

Tue, 02 Jan 2018 18:08:00 GMT

As the number of your services expands you're going to need to start thinking about how to organize them. Applying these two design patterns can help, provided you understand all their variations.

Managing Temporal Data in SQL Server 2016 and Azure SQL Database

Thu, 14 Dec 2017 16:00:00 GMT

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data.

Tracking History in SQL Server 2016 and Azure SQL Database

Tue, 12 Dec 2017 13:32:00 GMT

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the history of your data.

Retrieving and Updating JSON Objects in SQL Server 2016

Tue, 14 Nov 2017 17:29:00 GMT

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.

Building the Object Model You Want with Entity Framework

Thu, 09 Nov 2017 19:45:00 GMT

When it comes to inheritance, relational database theory and object-oriented programming have more in common than you might think. Understanding that overlap is critical in designing the object model that will generate the database design your application needs.

Querying JSON Data in SQL Server 2016

Thu, 19 Oct 2017 19:33:00 GMT

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

The Heisenberg Developer

Tue, 03 Oct 2017 13:06:00 GMT

There’s a potential security exploit that ASP.NET MVC leaves you open to. However, in Peter’s opinion, all the proposed solutions miss the point.

An Encryption Strategy

Thu, 28 Sep 2017 21:27:00 GMT

Encrypting data that you want stored in your View and returned to you when the user clicks the Submit button has its own special problems. Here’s a complete solution and, as a bonus, an Encryption object you can use anywhere.

Working with JSON in SQL Queries

Tue, 19 Sep 2017 13:15:00 GMT

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of.

Returning Simple Strings from Action Methods

Tue, 12 Sep 2017 13:40:00 GMT

When you want to return a string result -- either as text, HTML or XML -- then a ContentResult object gives you the right balance of simplicity and control.

The Future of Programming

Tue, 05 Sep 2017 19:52:00 GMT

If you’ve been programming long enough, then you know that the "right way to do things" keeps changing. Here’s why, a description of where we are now and a guess about where we’re going.

Quick Tip: Read the Inner Exception!

Thu, 31 Aug 2017 13:31:00 GMT

That's often where the real problem is.

LocalDB: The Database Without a Connection String

Tue, 29 Aug 2017 21:29:00 GMT

If you just want to get going with a code-first database, you don't even need to define a connection string -- just write your objects.

Exploiting the Validation Tools in ASP.NET MVC

Mon, 28 Aug 2017 19:30:00 GMT

Your users will make mistakes ... but it would be a mistake to treat all their errors the same way. You can get more out of ASP.NET MVC's validation infrastructure just by paying attention to how you name your errors.

Returning JSON from SQL Server Queries

Thu, 24 Aug 2017 12:39:00 GMT

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

Improving Feedback When Editing HTML

Fri, 07 Jul 2017 17:51:00 GMT

Get Visual Studio to be more helpful when you're working with HTML.