SQL Server and SDS


Reduce Trips to the Database Service with EF.E's Future Queries

One way to slow down your application is to make multiple trips to the database. Here's a way to cut those trips in half (at least) and it has to do with the EntityFramework.Extended library.

It's All About Character in C# and Visual Basic

How C# and Visual Basic handle characters and single-character strings is a bit inconsistent. There's no tidy solution, but it's something you do need to know.

Making Your Data Updates and Deletes More Efficient

By adding one open source library to your application (and adding two methods to your LINQ statements) you can cut the time spent on database updates and deletes in half.

R Language Basic Data Structures

Vectors, lists, arrays, matrices and data frames -- a look at five of the most fundamental data structures built into R.

LINQ Query Enters the Age of Big Data

Integrating distributed, in-memory computing with distributed caching can easily extend LINQ semantics to create important new capabilities for real-time analytics on fast-changing data.

Potentially Save a Trip to the Database with Updates in Entity Framework

Here's a tip about how to exploit Entity Framework's change tracking mechanism to -- possibly -- eliminate a trip to the database when you update an item. But, without some additional code, you probably can't use it.

A Lifetime of Data in C# and Visual Basic

Or, how lifetime can mean different lengths of time, depending on whether it's procedural- or block-level.

Integrating SQL Server Reporting Services Reports and ASP.NET MVC

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.

Permutations Using R

R has limited support for mathematical permutations, but it's there. Here's what R is capable of accomplishing.

Visual Studio 2015 Update 3, .NET Core and ASP.NET Core 1.0 Out Now

Finalized versions of Microsoft's venerable software technologies are now generally available, and for Visual Studio 2015 U3, it includes the resolution of some high memory consumption issues that bedeviled some larger VS customers.

Creating a Flexible, Extendable Update Process

In any real-world business, updating data isn't simple and changing the rows in the table is just the start of a complex set of processes. Fortunately, you can break those updates down into a bunch of simple processes that can be easily extended.

Use Lambda Expressions in LINQ Includes

You couldn't do it in earlier versions of Entity Framework but, in more recent versions, you can use lambda expressions to save yourself from some runtime errors.

Implementing Updates Without Query

The CQRS pattern separates updates from queries, allowing you to create the best process for each of those activities. Effectively, CQRS codifies the standard practice for ASP.NET MVC developers: Here are some strategies for implementing that pattern and improving your application's performance.

Now In The AWS Marketplace: WinDocks

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.

Entity Developer 6.0 Now Supports EF Core 1.0, Telerik's Data Access

New version allows for visual design and code generation of apps using Microsoft's newest Entity Framework Core 1.0, as well as popular data access framework from Telerik.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.