Best Database Article of February 2015

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.

Data Access using ServiceStack

6 Feb 2015Daniel Santillanes

Using ServiceStack's ORMLite framework as part of your MVC project's database access

VS2013

ADO.NET

Dev

Pivot Operator in SQL Server Simplified

7 Feb 2015Gaurav_Chaudhary

This tip is a brief introduction to Pivot operator in SQL Server

Money Precision Issues

15 Feb 2015Bohdan Stupak

This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

SQL

SQL-Server-2012

SQL-Server-2008R2

SQL Unit Testing

15 Feb 2015Ronnie Mukherjee

SQL Unit testing

SQL

WCF

CRUD Operation by MySqli procedural way in PHP

14 Feb 2015BD Star

Create-Read-Update-Delete(CRUD) operation by MySQLi procedural way in the PHP

MySQL

PHP

CRUD

Session 1: Setup SoftEther L2TP server on Amazon AWS Ubuntu

11 Feb 2015WoodyMou

Session 1: Setup SoftEther L2TP server on Amazon AWS Ubuntu

How to Use Ajax.BeginForm

1 Feb 2015Veronica S. Zotali

The tip aims to demonstrate the usage of Ajax.BeginForm

Get Ready to Learn SQL Server 19: Introduction to Sub Queries

4 Feb 2015essentialSQL

The purpose of this article is to introduce you to subqueries and some of their high-level concepts. There are a lot of details to cover in order to learn sub queries, but you’ll see we cover those in depth in later articles.

XML Manipulation With XML Copy Editor

16 Feb 2015Keyhole Software

XML Manipulation With XML Copy Editor

Get Empty or NULL Data Rows with Available Data Between Given Date Range in SQL Server

9 Feb 2015madan535

Get Empty or NULL Data Rows with available data between given date range in SQL Server

SQL

server

Debugging in Visual Studio with OzCode

2 Feb 2015Igal Tabachnik

Why you should use OzCode to debug your C# code in Visual Studio

DBA

product-showcase

IoT Makes the Perfect Microwave Burrito

25 Feb 2015Todd Christell, Canin Christell

Creating a Microwave Oven IoT Application

VITA – A Powerful and Flexible ORM and Additional Building Blocks for .NET Applications

10 Mar 2017Dave Clemmer

Going over key features of the VITA open source ORM and .net application framework, with sample SPAs using the MVC/AngularJS/WebApi/VITA technology stack.

Custom Roles Based Access Control (RBAC) in ASP.NET MVC Applications - Part 1 (Framework Introduction)

8 Jun 2015Stefan Wloch

An introduction to custom roles based access control in an ASP.NET MVC application using the Entity Framework.

Tutorial for a Basic WPF – MVVM Project Using Entity Framework

6 Feb 2015Richard Protzel

1 alternative

I decided to create my own sample project which connects to a named server (anSQL 2008 R2 server on my local machine – will also work on SQL Server 2012Express

A general-purpose service engine for unattended processing execution

23 Sep 2015Alberto Venditti

Using a .NET Windows service as an engine for specialized custom plug-ins execution

Read XML Files and Insert into Database Table

25 Jan 2016Gunaprasad Shetty

The tip provides the code snippet for inserting a huge XML file with details such as node level, node value, node desc and node child, etc.The snippet provides the solution for recursive reading of node and provides the value of XML nodes along with its value.

Adding security to our NoteKeeper JQuery Mobile App

26 Feb 2015Anele 'Mashy' Mbanga

Provide functionality to Sign In and Sign Up to enable security for our NoteKeeper JQuery Mobile App.

Angular Shopping Cart for Affiliate Marketing - Angular 5

22 Nov 2016Bill SerGio, The Infomercial King

Angular Shopping Cart for Affiliate Marketing in Angular 5 that Is Responsive with TV Commercials with Powerful Features that Drive Real Sales like Unlimited Distributor IDs for Commissions with Editor

OWIN OAuth2 authentication via Social networks

8 Feb 2015SupperSlonic

The Web API token based authentication via OWIN OAuth2 middleware supported by Facebook, Google, Microsoft.Extracting additional user's information from social networks.

Dependency Inversion Principle - What you always knew about DIP wasn't that accurate. Let's keep it simple

8 Feb 2017Rasik Bihari Tiwari

Let's understand exactly what is Dependency Inversion principle and what it is not. How people confuse it to be dependency injection which is it NOT.

Tips to fix CodedUI tests

24 Feb 2015JIANGWilliam

This article introduces some techniques to fix CoedUI automation tests, including a few generic approaches instead of much more specific functional definitions to handle problematic components such as Dialog and Table, SQL template to handle complex queries that generate test data and JavaScript bas

Tutorial for a Basic WPF – MVVM Project Using Entity Framework

17 Feb 2015Andrew Whiddett

This is an alternative for "Tutorial for a Basic WPF – MVVM Project Using Entity Framework"

Recursive CTE in SQL Server Simplified

7 Feb 2015Gaurav_Chaudhary

This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.

Contained Database – A New Feature in SQL SERVER 2012 TIP #81

26 Feb 2015Rajat-Indiandotnet

Contained Database–A new feature in SQL SERVER 2012 TIP #81

SQL-Server-2012

DBA

Interoperability with .NET Platform

22 Feb 2015Soufiane Rabhi

Communication between .NET and other programming languages

Role Based Security Architecture Using .NET MVC & JS

23 Feb 2015Tushar_Gupta

A custom security architecture for role based access to components in a page

Get Ready to Learn SQL Server 20: Using Subqueries in the Select Statement

6 Feb 2015essentialSQL

This is the second in a series of articles about subqueries. In this article, we discuss subqueries in the SELECT statement’s column list. Other articles discuss their uses in other clauses.

SQL

SQL-Server

Refresh ASP.NET Membership Database with SSIS

25 Feb 2015Mario K. Tacke

Refresh ASP.NET Membership Database with SSIS

What is the Difference between GROUP BY and ORDER BY

23 Feb 2015essentialSQL

What is the difference between GROUP BY and ORDER BY

Ways to Convert Microsoft ADOMD Data Source to JSON

25 Feb 2015Sibeesh Passion

Ways to Convert Microsoft ADOMD Data Source to JSON

Upload and Download Files with JDBC to SQL Servers

4 Feb 2015Dr. Song Li

This article presents an example to upload and download files with SQL server through JDBC in a Spring MVC application.

SQL Server Database Backup and Restore in C#

7 Feb 2015Syed Noman Ali Shah

How to take SQL server database backup and database restoration in C# using SMO

VS2013

SQL-Server-2012

LINQ To SQL Using C#

2 Feb 2015Ehtesham Mehmood

LINQ to SQL using C#

SQL

LINQ

Implementing UserRights in Winform App using Menustrip

21 Feb 2015SREENATH GANGA

Current Participants

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

Alberto Venditti

Technical Lead

Italy

I was born in 1970.

My first computer experience dates back to early 80s, with a Sinclair ZX81.
From that time on, as many "friends" say, my IT-illness has increased year by year.

I graduated in Electronic Engineering and earned the following Microsoft certifications:
MCP, MCT, MCDBA, MCSD, MCAD, MCSD for .NET (early achiever).

I worked in IT as a developer, a teacher, a consultant, a technical writer, a technical leader.
IT knowledge applied to real life is my primary interest and focus.

Andrew Whiddett

United States

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

Anele 'Mashy' Mbanga

Software Developer SITHASO HOLDINGS (PTY) LTD

South Africa

I'm a Bachelor of Commerce graduate, fell inlove with ICT years back with VB5. Used Pick & System Builder to create a windows app. Very curious, developed my first web database app called Project.Show using ExtJS. Published on Google Play Store, learned JQuery Mobile, a project manager at best. My first intranet app eFas with MySQL.

Fear closes people to a lot of things and we hold ourselves back being held by it. Thus the sooner you believe you can't do something, the sooner everything will work towards that belief. Believe in yourself at all times because you can do anything you set your mind to it!

I have a very beautiful woman and four kids, the best joys in the world. East London, South Africa is currently home.

Awards:

Best Mobile Article of February 2015 (First Prize)
http://www.codeproject.com/Articles/880508/Create-a-CRUD-web-app-using-JQuery-Mobile-and-Loca

Best Mobile Article of May 2015 (Second Prize)
http://www.codeproject.com/Articles/991974/Creating-JQuery-Mobile-CRUD-Apps-using-JQM-Show-Ge

Apps
Bible.Show (Android Store App)
https://www.facebook.com/bibleshow
https://play.google.com/store/apps/details?id=com.b4a.BibleShow

JQM.Show (Android Store App)
https://www.facebook.com/jqmshow
https://play.google.com/store/apps/details?id=com.b4a.JQMShow

CodeProject.Show (An offline CodeProject Article writer)
http://www.codeproject.com/Articles/993453/CodeProject-Show-A-CodeProject-offline-article-wri

BD Star

Software Developer

Bangladesh

I am a professional software developer. I have experience in analysis, design, development, testing and implementation of desktop(standalone),web and mobile platform. I have good exposure to object-oriented design, software architectures, design patterns, test-driven development and Project Management.

My Working Area:-

Programming Language: C, C++, Java, VB.NET, C#.NET.
Web Language: HTML5, XML, CSS3, JavaScript, JSON, jQuery, AJAX, PHP, ASP.NET.
Database Language: SQL.
Database Management System: Oracle, MS Access, MySQL.
Web development Server: Apache, Microsoft Personal Web Server, IIS.
Editor: Microsoft Visual Stdio, Codebock, Dev, GCC, Adobe Dreamwaver, Microsoft Fontpage, Netscape Composer, Netbeans, Sublime Text, TC.
Web FrameWork: twitter Bootstrap, 960 Grid System.
Design Pattern: MVC.
CMS: Wordpress, Joomla.
Operating System: Windows (NT,XP, Vista, 7), Linux (RedHat, Ubuntu)
Scripting Language: Linux Shell Scripting, Powershell Script
ERP System: Oracle JD Edwards
Mobile Platform: Windows, Firfox, Android.

Bill SerGio, The Infomercial King

CEO GeminiGroup TV, Inc.

United States

Bill SerGio is an accomplished entrepreneur and innovator, recognized in prominent publications such as Marquis Who's Who in America and Who's Who in Advertising. After completing medical school, he applied his expertise to marketing groundbreaking medical and software products through diverse platforms like newspapers, magazines, television, and the Internet. His efforts resulted in a his earning over $500 million a year, as featured in a People Magazine article about him. Today, Bill is a forward-thinking investor, leveraging artificial intelligence to drive research into new cures for diseases, while also backing cutting-edge movies and television projects. He created new techniques in AI and neural networking that enabled him to corner the market on half hour blocks of television time. His diversified interests and enormous financial success in both technology and entertainment make him a standout leader and investor in multiple industries.

Bohdan Stupak

Team Leader

Ukraine

Team leader with 8 years of experience in the industry. Applying interest to a various range of topics such as .NET, Go, Typescript and software architecture.

Daniel Santillanes

Web Developer swit

Mexico

Graduated from Hermosillo Institute of Technology in 2001. I started working as help desk and lost practice in programming. In march 2002 I had an excellent opportunity of going to Japan for training.

In Japan I had my first contact with .net with Visual Studio .net 2002 Professional. I really thank Onodera sensei for that opportunity.

When I returned in november 2002, I started working with PHP / MySQL, and 5 months later I returned to the roots of .net. I started working with Visual Studio .net 2003 and so far .net has been my focus.

Dave Clemmer

Software Developer Intelligent Coding Solutions, LLC

United States

I enjoy coding like an excellent beer. My particular passion and experience lies in the realm of modeling and code generation. In the late 80s and early 90s, I was involved in early modeling and code generation tools that reached the marketplace, including a tool that modeled FORTRAN programs and generated FORTRAN for parallel supercomputer architectures, and a tool that managed Shlaer-Mellor models and generated C++ code. Over the years, I have applied Shlaer-Mellor, UML, and custom modeling and various code generation techniques to greatly benefit the development of enterprise applications.

My current passion and endeavor is to foster the evolution of model oriented development. In particular, I am passionate about evolving the Mo+ model oriented programming language and related model oriented development tools, with as much community input as possible to achieve higher levels in the ability to create and maintain code. The open source site is at https://github.com/moplus/modelorientedplus.

Dr. Song Li

United States

I have been working in the IT industry for some time. It is still exciting and I am still learning. I am a happy and honest person, and I want to be your friend.

Ehtesham Mehmood

Software Developer MTP

Pakistan

Hello guys I am Computer Science graduate from University of Gujrat, Pakistan. I am an Entrepreneur , i have opened my own software house named as https://www.facebook.com/MTechnologiesPak in Pakistan. I am a self learner and love to explore new things. I also share my work and experiences on different sharing platforms.

My skills: C# Development , PHP Development, Web Development , HTML , CSS , jQuery, Java Script and also JAVA.

essentialSQL

Easy Computer Academy, LLC

United States

Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here http://www.essentialsql.com/get-started-with-sql-server/

Gaurav_Chaudhary

Web Developer

India

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

Gunaprasad Shetty

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.

Igal Tabachnik

Israel

Igal is a Senior Consultant and Instructor at CodeValue, an agile software developer with strong passion for programming and best software development practices.

He is an expert in creating and developing clean code, practices TDD and continuous refactoring to remove complexity, reduce bugs and achieve for better design.

Igal is a .NET Framework expert with strong background in .NET and Windows internals, as well as strong skills and knowledge in higher-level C# design patterns and methodologies. He has very big thirst for knowledge and continuous improvement. Igal is passionate about productivity, agile software development practices and methodologies, DevOPs and automation. Igal has many years of training under his belt, and frequently speaks about various topics at local and international conferences.

JIANGWilliam

Software Developer

Australia

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

madan535

Software Developer (Senior) eBiz Solutions http://venkatbaggu.com/

India

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

Mario K. Tacke

United States

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

Rajat-Indiandotnet

Team Leader

India

I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.

Rasik Bihari Tiwari

Software Developer 1E

India

My professional details will hardly make a difference to you if you have come to know about me after reading my lengthy article but my intent will make a difference for sure. Why I write articles is for the sole motto which I got to know pretty late in my career. My motto is that there is ONLY one way of enhancing knowledge and that way is sharing. Blogs, articles and white papers are nothing but a form of knowledge sharing. It also helps you creating a backup copy of the knowledge you have in your brain and nerves. This backup copy will surely outlive your life as this knowledge gets transferred to uncountable people through sharing. So start contributing now! Always remember my favorite quote - "Knowledge is the ONLY antidote to all fears. Start reading a new book today". Don't seek Nirvana. Seek knowledge. Nirvana and knowledge are synonymous.

Richard Protzel

United States

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

Ronnie Mukherjee

Software Developer

United Kingdom

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

Sibeesh Passion

Software Developer

Germany

I am Sibeesh Venu, an engineer by profession and writer by passion. I’m neither an expert nor a guru. I have been awarded Microsoft MVP 3 times, C# Corner MVP 5 times, DZone MVB. I always love to learn new technologies, and I strongly believe that the one who stops learning is old.

My Blog: Sibeesh Passion
My Website: Sibeesh Venu

Soufiane Rabhi

Technical Lead

France

Sofiene Rabhi is Microsoft certified professional in C# ,HTML 5 and JavaScript, Asp.net and Microsoft Silverlight, consultant, trainer specializing in application development with Microsoft technologies, including c#, Vb.net, and Microsoft Azure.

SREENATH GANGA

Software Developer

United Arab Emirates

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

Stefan Wloch

Architect

United Kingdom

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

SupperSlonic

Software Developer (Senior)

United States

https://supperslonic.com/
https://www.facebook.com/profile.php?id=100004059913750

Syed Noman Ali Shah

Software Developer raideIT Software Solution

Pakistan

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

Todd Christell

Architect Christell & Associates

United States

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

Tushar_Gupta

India

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

Veronica S. Zotali

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.

WoodyMou

Technical Lead

United States

I am a shameless software engineer and developer.
work-manic, sleepless animal, a crazy MCP, MCSE, MCDBA and SCJP.

First Prize	Sacha Barber - Bulk Insert Into SQL From C#
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	Alberto Venditti - A general-purpose service engine for unattended processing execution
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.