Articles by JasonShort (Articles: 2, Technical Blogs: 22)

Articles: 2, Technical Blogs: 22

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.18

Database Development
SQL Server	Use RegEx in SQL with CLR Procs 5 Jun 2010 Updated: 7 Aug 2017 Rating: 3.35/5 Votes: 8 Popularity: 3.03 Licence: CPOL Views: 45,776 Bookmarked: 24 Downloaded: 0 Please Sign up or sign in to vote. Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!
Programming Languages
SQL	Preparing an Entity Framework model for multi provider support 18 May 2010 Updated: 18 May 2010 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 102,877 Bookmarked: 20 Downloaded: 0 Please Sign up or sign in to vote. Preparing an Entity Framework model for multi provider support

Average blogs rating: 4.45

.NET
.NET4	LINQPad Helps You Learn LINQ [Technical Blog] 26 Feb 2010 Updated: 7 Aug 2017 Rating: 4.64/5 Votes: 14 Popularity: 5.32 Licence: CPOL Views: 32,050 Bookmarked: 29 Downloaded: 0 Please Sign up or sign in to vote. LINQPad helps you learn LINQ
ADO.NET
	Overview of ADO.NET [Technical Blog] 5 Jan 2012 Updated: 5 Jan 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 19,760 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. A high level overview of the ADO.NET object model and how VistaDB supports that model
All Topics
	VistaDB CLR Procs and Functions Introduction [Technical Blog] 4 Jun 2010 Updated: 4 Jun 2010 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 10,300 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. VistaDB CLR Procs and Functions Introduction
	Using EF 4.1 Code First to Support Multiple Database Vendors [Technical Blog] 23 Mar 2011 Updated: 7 Aug 2017 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 17,392 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. How to use EF 4.1 Code First to support multiple database vendors
Database Development
	Overview of ADO.NET [Technical Blog] 22 Feb 2010 Updated: 7 Aug 2017 Rating: 4.50/5 Votes: 10 Popularity: 4.29 Licence: CPOL Views: 29,891 Bookmarked: 33 Downloaded: 0 Please Sign up or sign in to vote. ADO.NET is a set of libraries included in the .NET Framework to facilitate the communication of applications with various data storage mechanisms. These libraries form the basis for all third parties to provide database access.
	10 Things to Make Your Desktop Database Apps Better [Technical Blog] 22 Feb 2010 Updated: 3 Feb 2011 Rating: 4.75/5 Votes: 14 Popularity: 5.44 Licence: CPOL Views: 34,682 Bookmarked: 48 Downloaded: 0 Please Sign up or sign in to vote. Here are 10 things to make your desktop database apps better
SQL Server	Building a plug-in model to load VistaDB - Part II [Technical Blog] 22 Jun 2010 Updated: 22 Jun 2010 Rating: 4.20/5 Votes: 3 Popularity: 2.00 Licence: CPOL Views: 11,870 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Plugins are used in data applications to support more than one provider from a single codebase. The Provider Factories in ADO.NET is one such example, but you cannot work with the provider specific features when you use these factories since they only implement generic ADO.NET functions.
LINQ
	LINQ Group By with NULL database values [Technical Blog] 3 Jan 2012 Updated: 3 Jan 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 12,680 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Group By with NULL database values in LINQ.
	LINQPad helps you learn LINQ [Technical Blog] 5 Jan 2012 Updated: 5 Jan 2012 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 32,510 Bookmarked: 11 Downloaded: 0 Please Sign up or sign in to vote. LINQPad is sort of like a Notepad, you can write and edit .linq files using it.
Plinq
	Speed Up Blocking Functions with PLINQ [Technical Blog] 4 Feb 2011 Updated: 4 Feb 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 9,400 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. How to speed up blocking functions with PLINQ
Programming Languages
C#	Migrate database schemas using SQL Script Generation [Technical Blog] 14 May 2010 Updated: 14 May 2010 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 16,201 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Migrate database schema across multiple vendor platforms
	Buffer.BlockCopy Not As Fast As You Think [Technical Blog] 3 Jan 2012 Updated: 3 Jan 2012 Rating: 2.00/5 Votes: 3 Popularity: 0.95 Licence: CPOL Views: 14,050 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. I recently wrote a quick test to prove something, that ended up being wrong…
	Entity Framework 4 New Operations [Technical Blog] 14 May 2010 Updated: 14 May 2010 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: CPOL Views: 17,561 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. There are some new operations in .NET 4 Entity Framework. This a quick example of each working with VistaDB 4 and Visual Studio 2010.
	Exposing OData from an Entity Framework Model [Technical Blog] 10 Jun 2010 Updated: 10 Jun 2010 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 37,411 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Exposing OData from an Entity Framework Model
	Entity Framework 4 New Operations [Technical Blog] 3 Jan 2012 Updated: 3 Jan 2012 Rating: 4.00/5 Votes: 2 Popularity: 1.20 Licence: CPOL Views: 13,480 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. New operations in the .NET 4 Entity Framework - a quick example of each working with VistaDB 4 and Visual Studio 2010
	Preparing an Entity Framework Model for Multi Provider Support [Technical Blog] 3 Jan 2012 Updated: 3 Jan 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 21,493 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. It is possible to use a single ADO.NET Entity Framework model between two database providers, but not without some extra work.
	Using EF 4.1 Code First to Support Multiple Database Vendors [Technical Blog] 3 Jan 2012 Updated: 3 Jan 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 13,451 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. How well the Code First aspect works with multiple database vendors using EF 4.1
	Speed Up Blocking Functions with PLINQ [Technical Blog] 3 Jan 2012 Updated: 3 Jan 2012 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 12,034 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Speed up blocking functions with PLINQ
C# 4.0	Buffer.BlockCopy Not As Fast As You Think [Technical Blog] 12 Mar 2010 Updated: 7 Aug 2017 Rating: 2.89/5 Votes: 7 Popularity: 2.44 Licence: CPOL Views: 73,907 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Buffer.BlockCopy is not as fast as you think
	LINQ Group By with NULL Database Values [Technical Blog] 5 Jul 2010 Updated: 5 Jul 2010 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: CPOL Views: 41,118 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. LINQ Group By with NULL database values
	Speed Up Blocking Functions with PLINQ [Technical Blog] 25 Jun 2010 Updated: 7 Aug 2017 Rating: 4.93/5 Votes: 13 Popularity: 5.49 Licence: CPOL Views: 21,480 Bookmarked: 16 Downloaded: 0 Please Sign up or sign in to vote. In this article, I want to cover a particular problem I have had many times over the years. How do you speed up multithreaded apps that are bound by blocking functions, or long running I/O operations?
SQL	LINQ to Entities Projection [Technical Blog] 13 Jul 2010 Updated: 7 Aug 2017 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 27,211 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. A few common SQL query patterns, and their Linq to Entities (EF) equivalents

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

JasonShort

Software Developer (Senior)

United States

I hold a PhD in computer science, and have been a practicing developer since the early 90's.

I used to be the owner for VistaDB, but sold the product to another company in August 2010.

I have recently moved to Redmond and now work for Microsoft. Any posts or articles are purely my own opinions, and not the opinions of my employer.

Articles by JasonShort (Articles: 2, Technical Blogs: 22)

Articles: 2, Technical Blogs: 22

Average article rating: 4.18

Database Development

Programming Languages

Average blogs rating: 4.45

.NET

ADO.NET

All Topics

Database Development

LINQ

Plinq

Programming Languages

Average tips rating:

Average reference rating:

Average project rating: