Best Database Article of June 2017

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.

DirectX and Pure Assembly Language: Doing What Can't be Done - Part I

8 Jun 2017CMalcheski

How to Create a Complete DirectX Game in Assembly Language

assembler

ASM

Windows

COM

DirectX

Dev

Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data

17 Jul 2017Vadim Loboda

Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order

SQL

VS2015

SQL-Server

SQL TVP Made Easy

26 Apr 2018Mason Kuck

I walk you through how to make use Table-valued parameters with one value

SQL

.NET

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017AhsanAhmed

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

Mysql 'statement level' Trigger … You Can Do It With Two Tricks

2 Jan 2022Eng Ahmed Taha

MySQL trigger workaround for statement-level triggers mimicking Oracle's behavior.

MySQL

trigger

Library Commander

19 Jun 2017Alexander Sharykin

LibraryCommander is a personal desktop application to manage my texts (e-book) collection, classify and search them by categories and tags.

A Database Initialiser for SQLite and NPoco

5 Jun 2021Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

Realm Mobile Database with Xamarin Forms Step By Step guide

8 Jun 2017S Ravi Kumar (TechieRathore)

Whenever we talk about offline data persistence in Mobile application using a database the only database comes in our mind is SQLite as it is [...]

database

Quick Tip: How to Exit from SQL*Plus on Command Line

5 Jun 2017Sam Varadarajan

How to exit from SQL&Plus on command line

SQL

WCF

Port machinery manufacturer ZPMC transforms its business with Azure IoT

27 Jun 2017Microsoft

ZPMC manufactures heavy-duty equipment that enables modern shipping. That equipment is a source of real-time data, which needs to be retrieved, monitored, and analyzed. ZPMC uses Microsoft Azure IoT Suite, Stream Analytics, and Microsoft Power BI to help it become a comprehensive service provider.

C# Slider/Trackbar Control using Windows Forms

9 Dec 2019Fabrice Lacharme

Yet another slider/trackbar in C#

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

7 Jun 2017Niemand25

Be careful with CASE WHEN when dealing with numeric columns and using zero literal

Database Transactions with Spring Framework

11 Jun 2017Arturs Solomencevs

About database transactions and using Spring Framework

Intro to Postulate ORM

13 Jun 2017Adam O'Neil (Travelers Rest, SC)

Introduction to Postulate, a code-first ORM for SQL Server made with Dapper

VS2013

SQL-Server

ORM

Using Oracle SQL Developer to Connect to MySQL/Mariadb Databases

29 Jun 2017Alvin Bunk

How to use Oracle SQL Developer to connect to MySQL/Mariadb databases

SQL

WCF

Grid View with AJAX based CRUD Operations in ASP.NET MVC 5

31 Jan 2018Ehsan Sajjad

In this post, I will be addressing this problem and we will learn that how can implement CRUD using JQuery DataTables in one page without any full page reloads.

GMapsTable: Usage

11 Jun 2017AivanF

Read how to add a dynamic table on Google map for your webpage

Current Participants

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

Adam O'Neil (Travelers Rest, SC)

Software Developer

United States

I'm into C#, SQL Server, and MVC. I also love cycling, but I'm really slow these days.

AhsanAhmed

Software Developer

Pakistan

Software Engineer and a clean code proponent, working on various .NET, Oracle and front end technologies including Web Forms, MVC, Web API, LINQ, EF, T-SQL, PL/SQL, SSIS, JavaScript, jQuery.

AivanF

Russian Federation

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

Alexander Sharykin

Russian Federation

.NET developer
View Alexander Sharykin GitHub profile; StackOverflow profile flair

Alvin Bunk

Software Developer Taft College

United States

I’m a software developer. Currently I’m working at Taft College as a Programmer.

Arturs Solomencevs

Latvia

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

CMalcheski

Software Developer (Senior) Contract Developer

United States

I work as a contract developer, specializing in assembly language driver software for specialized hardware. I also focus on identifying and removing performance bottlenecks in any software, using assembly language modifications, as well as locating hard-to-find bugs. I’m a specialist; I prefer to stay away from everyday, mundane development. I can fix problems in high level languages but as a rule I don’t like working with them for general development. There is no shortage of experienced developers in any language besides assembly. I am very much a niche programmer, a troubleshooter; the closer to the hardware I work, the happier I am. I typically take on the tasks others can’t or don’t want to do.

Ehsan Sajjad

Software Developer

Pakistan

Ehsan Sajjad is a Microsoft Certified Professional, Microsoft Certified C# Specialist and he is also among the top users on StackOverflow from Pakistan with 50k+ reputation at time of writing this and counting.

He is a passionate software developer with around 5 years of professional experience in Microsoft Technologies both web and desktop applications and always open to learn new things and platforms especially in mobile application development and game development.

Some Achievements :

5th Top Contributor from Pakistan on Stackoverflow.com
Top User in ASP.NET MVC from Pakistan on Stackoverflow.com
21st June 2017 - Article of the Day - ASP.NET Community (Beginners Guide on AJAX CRUD Operations in Grid using JQuery DataTables in ASP.NET MVC 5)
19th April 2017 - Article of the Day - ASP.NET Community (ASP.NET MVC Async File Uploading using JQuery)
March 2017 - Visual C# Technical Guru Silver Medal on Microsoft Tech Net Wiki Article Competition
20 January 2017 - Article of the Day - ASP.NET Community (Async File Uploading in ASP.NET MVC)
22nd September 2016 - Article of the Day - ASP.NET Community (GridView with Server Side Filtering, Sorting and Paging in ASP.NET MVC 5)
22nd August 2016 - Article of the Day - ASP.NET Community (Beginners Guide for Creating GridView in ASP.NET MVC 5)
December 2015 - C-SharpCorner Monthly Winner

Eng Ahmed Taha

Software Developer

Egypt

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

Fabrice Lacharme

Architect

France

Architect/engineer

Mason Kuck

Software Developer

United States

I am a .Net developer who mainly focuses on C# WPF/ASP.Net MVC

Microsoft

Web Developer

United States

Founded in 1975, Microsoft (Nasdaq “MSFT”) is the worldwide leader in software, services, devices and solutions that help people and businesses realize their full potential.

This is a Organisation

1 members

Niemand25

Business Analyst Linden

Lithuania

I'm a lawyer in a law firm. Programing is my hobby.

Private Dobbs

Software Developer (Senior)

United Kingdom

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

S Ravi Kumar (TechieRathore)

Architect

India

Hi There, I am an IT professional with 14 years of experience in architecting, designing and building IT solutions for complex business needs in form of mobile & web applications using Microsoft technologies. Currently working in an multinational company in India as Solutions Architect. The articles here are sourced from my blog : http://techierathore.com/

Sam Varadarajan

Software Developer (Senior) City of Los Angeles

United States

Originally a Physics major, fell in love with Microprocessors and switched to Computer Science 20+ years ago. Since then, dabbled in various languages including, PowerBuilder, Oracle, Java, C, C++, Perl, Python etc. Constantly striving for quality and performance too.

I try to help fellow developers with technology as a way of "giving back to the community". Blogging became a natural extension of that effort. Still learning to perfect that art. If one new programmer out there benefits from this blog, my time and effort are fully worth it.

The underlying theme in my blogs is power and beauty of programming (and technology in general). A well written program gives me the sense of awe you get when you look at a man made wonder like Angkor Wat. You experience poetry, art, mystique, power all at once. A program and the troubleshooting that ensues also gives you a feeling you get while reading a mystery novel!

Vadim Loboda

Russian Federation

"It is best to erase all personal history, because that would make us free from the encumbering thoughts of other people."

Journey to Ixtlan by Carlos Castaneda

First Prize	Arturs Solomencevs - Database Transactions with Spring Framework
Prize pool	CodeProject Mug - CodeProject


Second Prize	Vadim Loboda - Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data
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.
In the event an article has multiple authors and/or contributors, the number of prizes issued is solely at the discretion of the prize issuer.
In the event of a tie, 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.