Click here to Skip to main content
12,759,979 members (32,514 online)

Articles by JasonShort (Technical Blogs: 27)

Technical Blogs: 27

RSS Feed
No articles have been posted.

Average blogs rating: 4.47

Database
ADO.NET
Posted: 22 Feb 2010   Updated: 24 Feb 2010   Views: 18,921   Rating: 4.43/5    Votes: 6   Popularity: 3.45
Licence: The Code Project Open License (CPOL)      Bookmarked: 23   Downloaded: 0
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.
Posted: 22 Jun 2010   Updated: 22 Jun 2010   Views: 8,571   Rating: 4.20/5    Votes: 3   Popularity: 1.75
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
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.
Posted: 22 Feb 2010   Updated: 3 Feb 2011   Views: 27,923   Rating: 4.73/5    Votes: 14   Popularity: 5.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 47   Downloaded: 0
NOTE: This article was originally published on the VistaDB blog, but has been moved to this location permanently.Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it.Dat
Posted: 5 Jan 2012   Updated: 5 Jan 2012   Views: 14,560   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 0
A high level overview of the ADO.NET object model and how VistaDB supports that model.
General
Posted: 4 Jun 2010   Updated: 4 Jun 2010   Views: 6,900   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
VistaDB CLR Procs and Functions Introduction
SQL Server
Posted: 5 Jun 2010   Updated: 7 Jun 2010   Views: 21,564   Rating: 3.00/5    Votes: 4   Popularity: 1.81
Licence: The Code Project Open License (CPOL)      Bookmarked: 18   Downloaded: 0
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!
SQL Reporting Services
General
Posted: 14 May 2010   Updated: 14 May 2010   Views: 11,541   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Migrate database schema across multiple vendor platforms
C#
General
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 7,311   Rating: 2.00/5    Votes: 3   Popularity: 0.72
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
I recently wrote a quick test to prove something, that ended up being wrong…
.NET Framework
General
Posted: 14 May 2010   Updated: 14 May 2010   Views: 14,271   Rating: 4.50/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
There are some new operations in .NET 4 Entity Framework. This a quick example of each working with VistaDB 4 and Visual Studio 2010.
Posted: 18 May 2010   Updated: 18 May 2010   Views: 76,645   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 20   Downloaded: 0
Preparing an Entity Framework model for multi provider support
Posted: 10 Jun 2010   Updated: 10 Jun 2010   Views: 26,473   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Exposing OData from an Entity Framework Model
Posted: 12 Mar 2010   Updated: 26 Jun 2010   Views: 34,624   Rating: 3.43/5    Votes: 6   Popularity: 2.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
I recently wrote a quick test to prove something, that ended up being wrong…
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 10,800   Rating: 4.00/5    Votes: 2   Popularity: 1.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
There are some new operations in the .NET 4 Entity Framework, this a quick example of each working with VistaDB 4 and Visual Studio 2010.
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 14,940   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
It is possible to use a single ADO.NET Entity Framework model between two database providers, but not without some extra work.
How To
Posted: 3 Jul 2010   Updated: 5 Jul 2010   Views: 9,710   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 0
ClickOnce applications have many benefits including ease of deployment, optional automatic updates and framework requirement checks.The only real complicated issue with ClickOnce is how to deploy the database. I can’t imagine trying to deploy SQL Server as a part of your application!
Libraries
General
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 10,680   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
How well the Code First aspect works with multiple database vendors using EF 4.1.
LINQ
General
Posted: 7 Jun 2010   Updated: 7 Jun 2010   Views: 12,752   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
In this article, I will explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the ADO.NET Entity Framework.
Posted: 9 Jun 2010   Updated: 9 Jun 2010   Views: 11,581   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
In this article, I will continue to explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the ADO.NET Entity Framework.
Posted: 25 Jun 2010   Updated: 26 Jun 2010   Views: 12,220   Rating: 4.91/5    Votes: 12   Popularity: 5.30
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 0
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?
Posted: 26 Feb 2010   Updated: 26 Jun 2010   Views: 22,213   Rating: 4.93/5    Votes: 11   Popularity: 5.13
Licence: The Code Project Open License (CPOL)      Bookmarked: 26   Downloaded: 0
Have you tried to use LINQ to query a database using Visual Studio?  It can be a frustrating experience of things that compile fail at runtime, and that edit / compile / test cycle can quickly lead to hours of lost time trying to get a single complex query to work correctly.
Posted: 5 Jul 2010   Updated: 5 Jul 2010   Views: 19,613   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
LINQ is fantastic for the ability to write queries that express intent much more clearly than the same SQL, or structured code.  One problem that I have run into though is handling NULL database values that are part of a group by statement... 
Posted: 13 Jul 2010   Updated: 13 Jul 2010   Views: 19,595   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
A few common SQL query patterns, and their Linq to Entities (EF) equivalents
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 9,831   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Group By with NULL database values in LINQ.
Code Generation
General
Posted: 23 Mar 2011   Updated: 23 Mar 2011   Views: 10,703   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
With the release of the Entity Framework 4.1 I was interested to see how well the code first aspect works with multiple database vendors.
Uncategorised Technical Blogs
General
Posted: 4 Feb 2011   Updated: 4 Feb 2011   Views: 6,431   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
I have been studying the new PLINQ and Parallel Task Library in .NET 4 looking for various ways to do things that we can’t do in .NET 2.0. PLINQ is huge, and there are a lot of new ways to do multi threaded programming using .NET 4.
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 8,742   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Speed up blocking functions with PLINQ
Reviews on Third Party Products and Tools
Community Reviews
Posted: 5 Jan 2012   Updated: 5 Jan 2012   Views: 24,403   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
LINQPad is sort of like a Notepad, you can write and edit .linq files using it.
No tips have been posted.
No reference articles have been posted.

JasonShort
Software Developer (Senior)
United States 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.


Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 26 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid