Best Database Article of March 2014

This competition has ended

Overview
Entries
Participants
Winners
Prizes
Rules

Contribute to CodeProject and you'll automatically be in the running for a monthly prize!

Each month at CodeProject we gather together the best of the articles submitted the previous month and ask our readers to choose the best of the best. Entry is automatic - just submit you articke and we'll do the rest.

Check out the submission guidelines for information on posting articles.

Current Entries

Articles that match the contest criteria are automatically entered.

Spada via Modbus-micro SCADA for Arduino

28 Mar 2014jurhas

Spada via Modbs, Supervisory Control and Data Acquisition with visualb basic,Arduino and firebird

Windows

VS2010

SqlDataSource

Reduce the Size of MongoDB Documents Generated from .NET/C#

18 Mar 2014Pragmateek

How to reduce the size of MongoDB documents generated from .NET/C#

Binding of Calendar Controls from Database

8 Mar 2014SanSkun

How to bind holiday list and information about those holidays from database

SQL

ASP.NET

.NET Data Modeler for Oracle 11g

19 Mar 2014Jacob Himes

My go around to an Entity Framework alternative

.NET

Windows

DBA

Create a JMS Configuration on Oracle Weblogic 11g using WSLT

23 Jun 2019Octavio Sanchez Huerta

Python Script using WSLT

Python

Linux

Oracle

Creating a Windows Azure SQL Database

4 Mar 2014Malak Zia Nasir

Cloud computing is the trend of nowadays; this article provides some basic steps to create and connect a Windows Azure SQL Database to a simple application.

Out of memory issue in MyBatis

9 Mar 2014Davinder Singla

This tip is for solving out of memory issue for large result sets in MyBatis

XSD 1.1 Support in Liquid XML 2014

5 Mar 2014bconlon

XSD 1.1 support in Liquid XML 2014

Writing a 16-bit dummy kernel in C/C++

13 Mar 2014AshakiranBhatter

Understanding FAT file system and kernel programming in C/C++

C# WPF Dependency Injection Data Demo

21 Mar 2014Baxter P

Dependency Injection Data Demo with Lazy Loading and Data Mocking

Membership+ Management System, Part III: Query Intelligence

27 May 2014Shuqian Ying

Implementing a unified structured query system of service based relational data source with build-in intelligence.

Kerosene Dynamic Data Services

11 Mar 2014mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

Detecting Concurrency Issues with Entity Framework

14 Mar 2014Robert Lindblom

Detecting concurrency issues when using Entity Framework model first and SQL Server

ADO.NET

SQL-Server

Dev

.NET WinForms ReportViewer: Non-printable Report Background (Elements)

14 Mar 2014Nikita D. Sinelnikov

HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable

Kerosene ORM Dynamic Records In Depth

1 Mar 2015mbarbac

A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library

Expandable Table like Gridview

26 Mar 2014Nirav Prabtani

Virtual Expandable Gridview using Ajax post method

SQL

Ajax

ASP.NET

Multiple Actions from a Single VIEW Page in MVC

18 Mar 2014sankarsan parida

This is developed for using Index, Create, Edit and Delete operations in a Single View Page

Start With MVC - Push Start For Beginners(Part - 1)

11 Mar 2014Er. Puneet Goel

This article is about how to start with MVC. Its very simple and useful article that include basic Save, Update and Delete methods using MVC.

SQLite Helper (C#)

28 Mar 2014adriancs

Simplify the usage between C# and SQLite

SQLite

Entity Framework Tutorial for Beginners

7 Jul 2014Code Help 2014

A simple tutorial for beginners to learn the basics of Entity Framework. It will teach you how to perform CRUD operations using EF.

EntityUI Automatic UI Generator

19 Mar 2014Razi Syed

This is an alternative for "EntityUI Automatic UI Generator using CodeFirst Approach"

MongoDB Installation Scripts for Windows

17 Mar 2014x3F

Batch scripts that help install MongoDB on a Windows PC

ADO.NET – How to Call A Stored Procedure with Output Parameters?

24 Mar 2014Arun Ramachandran India

ADO.NET – How to call a stored procedure with output parameters?

ADO.NET

Using COM Binary Interface with C++

28 Mar 2014Romain Gailleton

A presentation on how to extract data from a Type Library (.tlb) and access COM Binary Interface from C++ using Qt

Thinking in SQL - Working with dates

14 Mar 2014Christian Graus

In this installment, I talk about working with dates and date functions in SQL Server

Custom Adding/Updating using Entity Framework 5

28 Mar 2014Kinyanjui Kamau

Being able to add or update data field by field through Winforms using EF5, .NET 4.5

.NET4.5

.NET

MySQL

Extending IDbConnection and getting help from Dapper for tedious tasks

31 Mar 2014Darek Danielewski

With a little help from C# Extensions and Dapper, it is easy to streamline coded database interaction, even with encrypted columns

MS SQL SERVER APPLY AND JOIN Keyword

16 Mar 2014Dinesh K.S. Kushwaha

Tip on CROSS APPLY and OUTER APPLY

Retrieve Unsaved/Lost SQL Script Files due to SSMS Crash or Accidental SSMS Termination

20 Jun 2021Elisha Cornelius

Recover SQL Script files that are lost due to SSMS Crash or whatever the other reasons

SQL

Jump Start: Using MongoDB with C#

25 Mar 2014Bibhu Dutta

Using MongoDB with C#

MongoDB

ASP.NET

Vacuole Encapsulation

24 Mar 2014Keyhole Software

Encapsulation approach to bring data sources and implementations closer together, allowing reflection-like behavior in a format that mere mortals can read.

SSIS Do I Union All or Merge??

28 Mar 2014derekman9707

SSIS - Do I Union All or Merge?

SQL

All-Topics

Database Integration With SQL Azure

14 Mar 2014nitinnigam21

This article will allow you to move your database from SQL Server to SQL Azure to enhance the performance of your application that has been deployed on the Azure Cloud.

SQL

DBA

SQL Script to Drop and Re-create All Foreign Keys in SQL Server

7 Mar 2014Nitinpatel

This SQL script will generate a script to drop and create all foreign keys in database.

Thinking in SQL - Distribution Functions in SS 2012

24 Mar 2014Christian Graus

Covering how to use the new Distribution functions in SQL Server 2012

Current Participants

Those with articles that match the contest criteria are automatically entered.

Nirav Prabtani

Team Leader eInfochips

India

Nirav Prabtani

I am a team lead, Database Architect and Designer /Technical Architect/Analyst,
Programmer in Microsoft .NET Technologies & Microsoft SQL Server with more than
4.5 years of hands on experience.

I love to code....!!!

My recent past includes my work with the education domain as a technical business
requirement analyst, database architect & designer and analyst programmer; just
love my involvement with the world of knowledge, learning and education and I think
I know quite well what I want to do in life & in my career. What do I like? Well,
ideation, brainstorming, coming up with newer and more creative ways of doing things;
each time with an enhanced efficiency. An item in my day's agenda always has a task
to look at what I did yesterday & focus on how I can do it better today

Contact Me

Nirav Prabtani

Mobile : +91 738 308 2188

Email : niravjprabtani@gmail.com

My Blog:
Nirav Prabtani

adriancs

Software Developer

Other

Programming is an art.

Arun Ramachandran India

Software Developer

India

Arun Ramachandran is a Software Engineer having hands on experience in different Microsoft Technologies who is presently working in Experion Technologies, India. He has written over 95 articles on the subject on his blog at http://BestTEchnologyBlog.com. Along with 3 years of hands on experience he holds a Master of Computer Applications degree from Cochin University of Science & Technology (CUSAT).

AshakiranBhatter

Software Developer

United States

Ashakiran is from Hyderabad, India and currently working as a Software Engineer in USA. He is a hobbyist programmer and enjoys writing code.

Baxter P

Software Developer

United Kingdom

I am a software developer working with Microsoft technologies since 2000.

Skills include C/C++, C#, VB.NET, MS SQL Server, ASP.NET Webforms/MVC, AngularJS, NodeJS, Sharepoint Development, WPF, WCF, Winforms, plus others.

bconlon

Software Developer

United Kingdom

Software developer and geek with 20 years coding experience mainly C++, C#, XML.
Please visit my developer blog: http://geekswithblogs.net/bconlon/Default.aspx

Bibhu Dutta

Software Developer Mindfire Solutions

India

Software developer, working at Mindfire Solutions, having hands on experience in both Windows and web application using C#, ASP.NET, ASP.NET MVC.

Christian Graus

Software Developer (Senior)

Australia

Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.

Code Help 2014

Software Developer (Senior)

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Darek Danielewski

Architect BI Software, Inc.

United States

A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.

Davinder Singla

Architect

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

derekman9707

Database Developer

United States

David retired as a Sergeant with the Cape Coral Police Department after 22 years of service. His final 10 years of duty were as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to Administrative Services in 2002 and was responsible for database administration, software integration, and development for public safety. David’s primary focus and expertise is with SQL Server, reporting services, integration services, and analysis services, and he was recognized for his work by SQL Server Magazine as “Innovator of the Year” runner up in 2007. David is an MCITP for SQL Server 2005 and 2008 in both database administration and business intelligence and is a Microsoft Certified Trainer. He regularly posts on the MSDN SQL Server forums where he also serves as a moderator, and is a contributor at SQLCLR.net. In addition to his knowledge of SQL Server David works as a software developer using VB.net and C# and has worked extensively in SharePoint development.

Dinesh K.S. Kushwaha

Team Leader Kochar Infotech Pvt. Ltd.

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Elisha Cornelius

Chief Technology Officer

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Er. Puneet Goel

Software Developer

India

Puneet Goel is an IT Professional with 8+ years. He is specialized in Microsoft Technologies (Asp.NET, SQL Server, Ajax, Jquery, JavaScript, MVC, and Angular). He is an avid member of several development communities and a serial blogger.He loves to learn new technology, do experiments with existing ones, and always happy to help the community.

Jacob Himes

Software Developer

United States

Jacob is an innovative software engineer with a proven track record in creating viable complete software solutions from complex problems quickly and effectively. Possesses a tremendous passion for discovering and taking advantage of absolute cutting edge technology the IT world offers, and applying novel solutions while adhering to traditional best practices. Demonstrates a strong background in enterprise business software, and coordinating complex initiatives.

jurhas

Italy

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Keyhole Software

Keyhole Software

United States

Keyhole is a software development and consulting firm with a tight-knit technical team. We work primarily with Java, .NET, and Mobile technologies, specializing in application development. We love the challenge that comes in consulting and blog often regarding some of the technical situations and technologies we face. Kansas City, St. Louis and Chicago.

This is a Organisation

3 members

Kinyanjui Kamau

Software Developer (Senior) GetNet

Kenya

http://www.kinyanjuikamau.com

Malak Zia Nasir

CEO

Philippines

Old profile

mbarbac

Spain

mbarbac has worked in start-ups, multinational tech companies, and consulting ones, serving as CIO, CTO, SW Development Director, and Consulting Director, among many other roles.

Solving complex puzzles and getting out of them business value has ever been among his main interests - and that's why he has spent his latest 25 years trying to combine his degree in Theoretical Physics with his MBA... and he is still trying to figure out how all these things can fit together.

Even if flying a lot across many countries, along with the long working days that are customary in IT management and Consultancy, he can say that, after all, he lives in Spain (at least the weekends).

Nikita D. Sinelnikov

Russian Federation

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

nitinnigam21

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Nitinpatel

Database Developer

United Kingdom

With 10 years of experience of working on Microsoft platform, currently I am working as Database/BI expert.

Octavio Sanchez Huerta

Software Developer (Senior) Banco Monex

Mexico

My interest is in academic research and trying to keep me in the field to obtain a PhD degree, welling on the way to combine a job in a company with the activity I enjoy.

Pragmateek

Instructor / Trainer Pragmateek

France (Metropolitan)

To make it short I'm an IT trainer specialized in the .Net ecosystem (framework, C#, WPF, Excel addins...).
(I'm available in France and bordering countries, and I only teach in french.)

I like to learn new things, particularly to understand what happens under the hood, and I do my best to share my humble knowledge with others by direct teaching, by posting articles on my blog (pragmateek.com), or by answering questions on forums.

Razi Syed

Software Developer (Senior)

United States

My area of expertise is developing management database systems for business so that they can efficiently store and lookup existing customer's information and related data, and be able to generate various reports. My goal is to always deliver innovative design and a user friendly interface.

Robert Lindblom

Software Developer (Senior)

Sweden

Working as an independent software contractor, specializing in .Net technologies.

Romain Gailleton

Engineer

France

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

sankarsan parida

Software Developer

India

Hi all,I am Sankarsan Parida,I am working as a Software Engineer in CTS Kolkata. I have around 4 years of experience in developing the web applications. My areas of interest are C#.Net, Ajax, Sql server, MongoDB, MVC, WCF

SanSkun

Software Developer

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Shuqian Ying

Founder CryptoGateway Software Inc.

Canada

His interests in software research and development include security, domain specific meta-language development technologies and tools, meta-language driven code generation, generation of non-invasive and virtual SQL database for "un-structured" data (sqlization), automated relational data service production technologies, file system sqlization technologies and products, structured multi-lingual documentation tools and technologies, sqlization of user's personal data, like emails, etc.. He likes to use distributed code version control system to manage codes. For that reason, a tool to manage git repository forest (related git repositories) was even developed internally.

He was a physist before year 2000. He studied theoretical physics (the hidden symmetry between the past and future, quantum field theories, mirror universe, cosmological dark energies etc.) in which he think to had made fundamental breakthroughs[^] but the community is either not ready for it or is actively rejecting/ignoring it Smile | :) .

It struck me on Apr. 11, 2023 that the said theory above can even generate General Relativity naturally after a recent discussion in the Insider News group that triggers a rethinking of the subject on my side. I know how G can be computed in principle now...

Most recent software system to share:

V-NET[^] - Full stack virtualization management system including networking, storage, virtual machines and containers, with an emphasis on networking ... to be released.

x3F

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

First Prize	Christian Graus - Thinking in SQL - Working with dates
Prize pool	CodeProject Special Mug - CodeProject


Second Prize	adriancs - SQLite Helper (C#)
Prize pool	Bob Sticker - CodeProject

Contest Entries and Requirements

The contest period covers the the first day of the month 12AM US Eastern Standard Time and ends the final day of the month at 11:59:59 PM US Eastern Standard Time. All entries must be submitted during this period in order to qualify.
Entries must be an article, or blog entry.
With the exception of the Everything Else category, the article must be tagged with at least one of the tags corresponding to that competition's category (for example, to enter the C# Competition you would need to tag your article with a C# tag).
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
Articles may only be considered for a single category. If an article is eligible for multiple categories (for example, it pertains to both the C# and Web Dev categories), CodeProject editors and judges will decide which category the article shall be entered in.
No author can be nominated twice in the same category.
If an author writes has two separate articles, each article may be considered in their respective categories provided none of the aforementioned rules are broken. For example, if an author wrote two separate articles, one related to C# and one related to VB.NET, the author and articles could be nominated in the C# and VB.NET competitions, respectively.
In the event an author wins multiple competitions, and repeat, identical prizes, the number of prizes issued is solely at the discretion of the prize issuer.
Multiple votes from the same IP will be automatically disqualified.
The judges’ decision is final and no correspondence will be entered into.
Only those who live in jurisdictions in which this contest is legal may enter.
Any breach of the rules and the prize will be awarded to the runner up.
By entering the contest you agree to the rules, conditions of entry, and agree that your member alias and any submitted material can be used for promotional purposes by CodeProject.
Entries shall be deemed to be submitted by the authorized account holder of the email address submitted at the time of entry unless clearly indicated otherwise. "Authorized account holder" is defined as the natural person who is assigned to an email address by an internet access provider, on-line service provider, or other organization (e.g. business, educational institution, etc.) that is responsible for assigning email addresses for the domain associated with the submitted email address.

Eligibility

This competition is open to software development professionals & enthusiasts who are of the age of majority in their jurisdiction of residence; however, residents of Quebec and of the following countries are ineligible to participate due to legal constraints: Cuba, Iran, Iraq, Libya, North Korea, Sudan, and Syria. Employees (or a member of their immediate family) of CodeProject or any of their affiliates, subsidiaries, advertising or promotional agencies are also ineligible to participate. Void where prohibited by law.

How to Enter

Entry is by the submission process described above. Please read the submission requirements before submitting your entry and ensure the article is tagged with at least one of the tags corresponding to that competition's category.

Lost, late, misdirected, or illegible entries will be disqualified. Any entry containing content that CodeProject deems objectionable for any reason will be disqualified. All decisions of CodeProject with respect to any aspect of the competition, including, without limitation, the eligibility of entries, are final and binding on all entrants in all matters as they relate to this competition. CodeProject reserves its right to modify the Rules.

CodeProject assumes no responsibility for lost, late, delayed, destroyed or misdirected mail, voice messages, email or any computer errors or malfunctions. No correspondence will be entered into with entrants.

CodeProject does not assume any responsibility for incorrect or inaccurate capture of entry information, technical malfunctions, human or technical error, lost, delayed or garbled data or transmissions, omission, interruption, deletion, defect or failures of any telephone or computer line or network, computer equipment, software or any combination thereof. Entry materials/data that have been tampered with or altered are void. If for any reason, in the opinion of CodeProject in its sole discretion, the competition is not capable of running as originally planned, or if the administration, security, fairness, integrity or the proper conduct of the competition is corrupted or adversely affected, including by reason of infection by computer virus, bugs, tampering, unauthorized intervention, fraud, technical failures or any other causes beyond its control, CodeProject reserves its right to cancel, terminate, modify, amend, extend or suspend the competition including cancelling any method of entry, and select a winner from previously received eligible entries. CodeProject reserves its right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the competition or to be acting in violation of the Rules or otherwise in a disruptive manner. CodeProject reserves its right to seek remedies and damages to the fullest extent of the law for any attempts to deliberately damage the competition web site or to undermine the legitimate operation of this competition. CodeProject shall not be held responsible for any errors or negligence that may arise or occur in connection with the competition including any damage to an entrant's computer equipment, system, software or any combination thereof, as a result of their participation in this competition or from downloading any material from the competition website where applicable.