Click here to Skip to main content

Articles by JasonShort (Technical Blogs: 27)

Technical Blogs: 27

RSS Feed
No articles have been posted.

Average blogs rating: 4.38

Database
ADO.NET
Posted: 22 Feb 2010   Updated: 24 Feb 2010   Views: 14,251   Rating: 4.43/5    Votes: 6   Popularity: 3.45
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   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: 6,856   Rating: 3.67/5    Votes: 2   Popularity: 1.10
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   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: 22,736   Rating: 4.73/5    Votes: 14   Popularity: 5.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 48   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.Data dri
Posted: 5 Jan 2012   Updated: 5 Jan 2012   Views: 9,361   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: 5,069   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
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: 11,388   Rating: 3.00/5    Votes: 3   Popularity: 1.91
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   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: 8,025   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: 4,282   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: 10,749   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: 16,627   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
Preparing an Entity Framework model for multi provider support
Posted: 10 Jun 2010   Updated: 10 Jun 2010   Views: 15,092   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: 22,175   Rating: 2.75/5    Votes: 4   Popularity: 2.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   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: 8,351   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: 10,269   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: 7,272   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: 8,210   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: 9,693   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: 8,772   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: 9,684   Rating: 4.91/5    Votes: 12   Popularity: 5.30
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   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: 16,552   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: 10,524   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   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: 13,878   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
A few common SQL query patterns, and their Linq to Entities (EF) equivalents
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 8,000   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: 7,451   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.  Could you use the code first modeling to change the database through a connection string?  I thought it might be worth a quick sample app to find out.Download th
Uncategorised Technical Blogs
General
Posted: 4 Feb 2011   Updated: 4 Feb 2011   Views: 4,674   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. In this article, I want to cover a particular problem I have
Posted: 3 Jan 2012   Updated: 3 Jan 2012   Views: 7,286   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
General
Posted: 5 Jan 2012   Updated: 5 Jan 2012   Views: 14,796   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   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.
Follow on   Twitter


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 20 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid