Best Database Article of November 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.

Uploading the Files – HTML5 and jQuery Way!

28 Nov 2014Afzaal Ahmad Zeeshan

Uploading the files - HTML5 and jQuery way

HTML

.NET

Windows

Generator for SQLite Use in Android

13 Nov 2014A.Ebrahimi

Tools introduction for Android developers who use SQlite in coding

Android

Mobile

SQLite

Handling Entity Framework Stored Procedure ResultSets Polymorphically

25 Nov 2014David Killian

A reflective approach to providing stored procedure based data access methods with a reuse pattern based on polymorphic Types as arguments in ObjectResult

Azure: SQL Azure

9 Nov 2014Sacha Barber

SQL Azure

SQL

WCF

Connect MongoDB from Any Working Directory on ubuntu

4 Nov 2014binit.ku.singh

Connect MongoDB from any working directory on ubuntu

MongoDB

NoSQL

database

Get Ready to Learn SQL Server: 17. How to Use the Intersect Operator

31 Oct 2014essentialSQL

How to use the Intersect Operator in SQL Server

Shrink All Databases on SQL Server

2 Nov 2014Manas Bhardwaj

This post is intended to be used as a hack for developers to release some disk space. Please do not use on actual production environments.

SQL

SQL-Server

DBA

DbKeeperNet - How to Seed ASP.NET Users and Roles

24 Nov 2014voloda2

DbKeeperNet - How to seed ASP.NET Users and Roles

MySQL

DBA

Windows 7 Files

12 Nov 2014Alexandros Pappas

Lists the files that are installed with Windows 7 on a Virtual PC

SQL

Windows

server

Create, Run, Debug and Deploy SQL CLR Function with Visual Studio 2013 Database Project

24 Nov 2014Sunil_Pawar

Learn how quickly you can Create, Run, Debug and Deploy SQL CLR function using integrated features of Visual Studio 2013.

The Semantic Database In Action

4 Nov 2014Marc Clifton

A Feed Reader Use Case, demonstrating in part how the Semantic Database works, as well as the Higher Order Programming Environment IDE

Unknown Class Dynamically Generated at runtime for Entity Framework, WCF OData and dynamic client consumption

7 Nov 2014Adriaan Booysen

An example of a nearly complete unknown type being used accross EF, WCF and consumed client side

A First Look at NoSQL and MongoDB in Particular

16 Mar 2015Sander Rossel

Getting your feet wet in NoSQL with MongoDB!

Passing Table Valued Parameters with Dapper

31 Oct 2014Darek Danielewski

Up until version 1.26 of Dapper, it was not possible to utilize TVP.

Generic Insert for Dapper

20 Nov 2014Jakob Lithner

Dapper offers fast database handling with custom SQL strings. This wrapper simplifies life by taking generic POCO objects and creates necessary SQL strings on the fly, and it is still very fast!

How Do I Use SQL Server to Sort Alphanumeric Values?

14 Nov 2014essentialSQL

Sort Alphanumeric Values with SQL Server

Single Page Application using AngularJS and Web API and Responsive using Bootstrap.

20 Nov 2014Khademul Basher

This article describes the AngularJS JavaScript framework and shows how to use it to develop a Single Page Application.

Repository Pattern using Dependency Injection (Autofac) in MVC application

19 Nov 2014Akshit Rana

In this article, I will explain how to implement Respository pattern and how to enable dependency injection feature to your MVC Application.

Efficient Representation of a Semigroup in C++

20 Nov 2014Vadim Stadnik

Generality and efficiency of a semigroup in C++ are achieved by using an augmented B+ tree. Basic and advanced applications of such a semigroup are discussed.

Cursors Vs. Sets

19 Nov 2014Sums Mohs Eds

A brief discussion of when to use cursors and when to use sets.

ASP.NET MVC Web App on 3-Tier for Beginners – Part 1

12 Nov 2014Mohd Manzoor Ahmed

ASP.NET MVC Web App on 3-Tier for Beginners – Part 1

SQL

MVC

ASP.NET

Pivot Table Using Linq Entity and SQL Server 2008 R2 for Dynamic Columns

20 Nov 2014Avinash Narnaware

How to create Pivot Table in SQL Server 2008 R2 and in C# Linq to Entity Framework in a step by step manner with two different instances.

MySql Tool

6 Nov 2014Syed M Hussain

A MySql utility tool that can export database tables and generate ORM entities

MySQL

PHP

Using a Database With Your Android* App

17 Nov 2014Android on Intel

In this article we will take a look at Android* SQLite API and helper classes for database creation and maintenance.

Android

Mobile

SQLite

Database Driven Properties

12 Nov 2014Christopher Crain

Create a dynamic class driven by your database.

Using C# to Connect to and Query from a SQL Database

16 Mar 2015Sander Rossel

Using C# to get data in- and out of your (relational) database

Xamarin + SQlite + Android

2 Nov 2014Ullas_Krishnan

How to use SQLite with Xamarin C# Android

Create SQL Server Database Unit Tests

11 Nov 2014Bert O Neill

Create unit tests for your stored procedures\triggers\functions and integrate into TFS continuous integration cycle

Easy Database Table Change History

5 Nov 2014Johnny L Washington

Capture data changes in history table

How To Send Mail Using SQL Server: Part 1

25 Nov 2014Manish kumar choudhary

In this article, we are going to learn the concept of mail sending using SQL Server.

SQL-Server-2012

Multi-Tenancy System With Separate Databases in MVC

3 Oct 2017Gavin Coates

Creating a multi-tenancy system where each tenants data is stored in a separate database, using ASP.NET MVC

SQL Subqueries

6 Nov 2014Patrycja Dybka

This tip describes what a subquery is and covers some basic examples.

SQL

Hashing Passwords using ASP.NET's Crypto Class

20 Nov 2014Afzaal Ahmad Zeeshan

This article provides an overview of the hashing process of passwords in ASP.NET's Crypto class.

WCF Restful Service Form Authentication

6 Nov 2014sandeep12jain

WCF Restful Service Authentication without SSL Certificate

Using DataSets to work with (relational) in-memory data

16 Mar 2015Sander Rossel

Need some flexible in-memory data cache? DataSets might be what you're looking for...

Right vs. Left Outer Join

11 Nov 2014Patrycja Dybka

The explanation of left and right outer join.

SQL

Use Of Self Joins Instead Of Cursor Or While Loop

5 Nov 2014Shweta N Mishra

Retrieving Running balance in easy steps and less time

SQL

Import Data from Excel to SQL Using SSIS 2012 Dynamic Configuration

25 Nov 2014sudheer mattapally

How to import data from Excel to SQL using SSIS 2012 Dynamic Configuration

SQL

VS2010

Visual-Studio

Control Not Found in Namespace but App Compiles Fine

17 Nov 2014#realJSOP

How to fix this ANNOYING problem

Think & Eat

4 Nov 2014Santhoshpettacode

Make to Cook any one with health care service to the user

Current Participants

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

#realJSOP

Software Developer (Senior) Paddedwall Software

United States

I've been paid as a programmer since 1982 with experience in Pascal, and C++ (both self-taught), and began writing Windows programs in 1991 using Visual C++ and MFC. In the 2nd half of 2007, I started writing C# Windows Forms and ASP.Net applications, and have since done WPF, Silverlight, WCF, web services, and Windows services.

My weakest point is that my moments of clarity are too brief to hold a meaningful conversation that requires more than 30 seconds to complete. Thankfully, grunts of agreement are all that is required to conduct most discussions without committing to any particular belief system.

A.Ebrahimi

Web Developer

Iran (Islamic Republic of)

I am developing Android apps, developing web service needed for apps in ASP.NET C#, and SQL, javascript, css, html coding.
I have been developing Delphi applications, and started decades ago from developing Foxpro.

Adriaan Booysen

Software Developer (Senior) Self Employed

South Africa

I am a well seasoned developer with 18 years experience in the industry and have been working on C# since .Net 1 made its debut, which is since 2002 and remember all the hardcore work that needed to be done and has seen how it evolved. I have written multitudes of solutions in .Net for many customers and always learn something new.

Needles to say, my repertoire does not start and end with .Net and includes tech knowledge from database, servers, applications across various streams, not just Microsoft technologies.

In the future I will attempt to hand some of my knowledge down to the community, since it has helped me so many times over the years.

Afzaal Ahmad Zeeshan

Software Developer

Pakistan

Afzaal Ahmad Zeeshan is a computer programmer from Rabwah, Pakistan, currently living in The Netherlands, likes .NET Core and Node.js for regular everyday development. Afzaal Ahmad works at Adyen as a Developer Advocate.

He is an expert with Cloud, Mobile, and API development. Afzaal has experience with the Azure platform and likes to build cross-platform libraries/software with .NET Core. Afzaal is an Alibaba Cloud MVP, twice he has been awarded Microsoft MVP status for his community leadership in software development, four times CodeProject MVP status for technical writing and mentoring, and 4 times C# Corner MVP status in the same field.

Akshit Rana

3 pillarglobal

India

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

Alexandros Pappas

Software Developer (Senior) Unisystems

Greece

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

Android on Intel

United States

Intel is inside more and more Android devices, and we have tools and resources to make your app development faster and easier.

Avinash Narnaware

Product Manager GENPACT

India

Working as Product Manager in GENPACT. Very much passionate about coding. Good exposure in salesforce technology. Total 9 year experience in IT programming. Mostly worked over Sale cloud, Service Cloud. Proficient in Salesforce Lightning, Apex class, trigger, OOB functionality, Apex Batch Class, API integration(REST and SOAP). Have Admin, SalesforcePlatform Developer 1 and Salesforce Platform Developer 2 certified developer.

Bert O Neill

Architect

Ireland

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

binit.ku.singh

Software Developer

India

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

Christopher Crain

Engineer Rockwell Collins

United States

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.

David Killian

Architect SoftwareDo, Inc.

United States

I'm the President and Chief Architect of SoftwareDo, Inc. I've spent most of my career architecting, designing, and implementing large distributed compute systems for the retail industry, mostly focused on the Point-Of-Service problems. Most of this has work has been done on the Microsoft platforms.

I have extensive experience in COM, C++, Sql Server, and C#. I have a longterm interest in domain specific modeling leading to metadata driven code generation. I've been involved with WCF from the earliest TAP programs at Microsoft onward. My current focus is on distributed, enterprise level Service Oriented Applications using WCF and the Azure service bus.

I hold a BS in Physics from Northwest Missouri State University and a PhD in Astronomy from the University of Florida.

My major avocation for the last 40 years has been as a martial arts instructor. I hold a 4th degree blackbelt in karate and a 5th degree blackbelt in aikido.

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/

Gavin Coates

Software Developer

United Kingdom

Gavin Coates is a software developer from Southwest Scotland. Gavin works primarily with web based technologies such as Microsoft ASP.NET. Gavin also has experience of developing industrial control systems using ICONICS, Modbus and OPC technologies. Gavin also also an aviation enthusiast, and loves to travel.

Jakob Lithner

Software Developer (Senior)

Sweden

20 years of development on Microsoft platform.

Johnny L Washington

Architect

United States

I love development.

Khademul Basher

Founder http://softwarelandmarks.com/

Bangladesh

I am in Software Development for more than 12 years. I am expert on Microsoft Platform for Web Forms, MVC, MVC Core, Web API, Desktop App, PHP etc. I am also expert on jQuery, AngularJS, Bootstrap, Font Awesome, Telerik UI, Kendo UI etc. I know BackboneJS, KnockoutJS also. I am an article writer. I have many articles in CodeProject.

Email: khademulbasher@gmail.com

Manas Bhardwaj

Architect

Netherlands

Read my personal blog at www.manasbhardwaj.net.

Manish kumar choudhary

Software Developer

India

Manish Kumar Choudhary is a passionate and pragmatic software engineer specializing in web application development with ASP.NET MVC, Web API, Entity Framework, NHibernet, Angular, Backbone, HTML5, and CSS. He started programming at the age of twelve on VB.Net and fell in love with it. His dream at the time was to become a software engineer so he pursues programming both academically and professionally. He has a Bachelor of Science in Computer Application and a Master of Science in Computer Application. He has over 3.5 years’ professional experience developing web applications. Outside the software world, he enjoys photography, swimming, cricket and football. Manish is based in Hyderabad, India.

Marc Clifton

Architect Interacx

United States

Blog: https://marcclifton.wordpress.com/
Home Page: http://www.marcclifton.com
Research: http://www.higherorderprogramming.com/
GitHub: https://github.com/cliftonm

All my life I have been passionate about architecture / software design, as this is the cornerstone to a maintainable and extensible application. As such, I have enjoyed exploring some crazy ideas and discovering that they are not so crazy after all. I also love writing about my ideas and seeing the community response. As a consultant, I've enjoyed working in a wide range of industries such as aerospace, boatyard management, remote sensing, emergency services / data management, and casino operations. I've done a variety of pro-bono work non-profit organizations related to nature conservancy, drug recovery and women's health.

Mohd Manzoor Ahmed

Founder ManzoorTheTrainer.com

India

Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.

"I focus on simplifying, complex concepts..." - ManzoorTheTrainer

Founder of www.ManzoorTheTrainer.com [Free .net video tutorials on MS SQL Server, Asp.Net, C#.Net, Ado.Net, Entity Framework, MVC, Web Services, Android]

Patrycja Dybka

Technical Writer Vertabelo

Poland

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

Sacha Barber

Software Developer (Senior)

United Kingdom

I currently hold the following qualifications (amongst others, I also studied Music Technology and Electronics, for my sins)

- MSc (Passed with distinctions), in Information Technology for E-Commerce
- BSc Hons (1st class) in Computer Science & Artificial Intelligence

Both of these at Sussex University UK.

Award(s)

I am lucky enough to have won a few awards for Zany Crazy code articles over the years

Microsoft C# MVP 2016
Codeproject MVP 2016
Microsoft C# MVP 2015
Codeproject MVP 2015
Microsoft C# MVP 2014
Codeproject MVP 2014
Microsoft C# MVP 2013
Codeproject MVP 2013
Microsoft C# MVP 2012
Codeproject MVP 2012
Microsoft C# MVP 2011
Codeproject MVP 2011
Microsoft C# MVP 2010
Codeproject MVP 2010
Microsoft C# MVP 2009
Codeproject MVP 2009
Microsoft C# MVP 2008
Codeproject MVP 2008
And numerous codeproject awards which you can see over at my blog

sandeep12jain

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.

Sander Rossel

CEO JUUN Software

Netherlands

Sander Rossel is a Microsoft certified professional developer with experience and expertise in .NET and .NET Core (C#, ASP.NET, and Entity Framework), SQL Server, Azure, Azure DevOps, JavaScript, MongoDB, and other technologies.

He is the owner of JUUN Software, a company specializing in custom software. JUUN Software uses modern, but proven technologies, such as .NET Core, Azure and Azure DevOps.

You can't miss his books on Amazon and his free e-books on Syncfusion!

He wrote a JavaScript LINQ library, arrgh.js (works in IE8+, Edge, Firefox, Chrome, and probably everything else).

Check out his prize-winning articles on CodeProject as well!

Santhoshpettacode

Web Developer PettaCode

India

I started the business with my friends, started Pettacode for supporting branding .Pettacode gives you best service to handle your brand very easily.I cant make regular update on codeproject if your have any queries related to my service feel free to mail me : info@pettacode.com .Our main policy is to give a customer a best service with reasonable cost .Iam expert in developing application on major mobile platform and also testing and UI work in software . I will be sharing my work with all my working partners and make any project success.
For more details about my status see this website :- Pettacode.com

Shweta N Mishra

Software Developer

India

I am a working professional and , I am here to learn and share the knowledge about technologies.

sudheer mattapally

United States

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

Sums Mohs Eds

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.

Sunil_Pawar

Software Developer (Senior)

Australia

Sunil Pawar has completed his Bachelor of Engineering (Information Technology)in 2004 from India.
He is a Microsoft Certified Professional (C# .Net).Sunil started Programming with VB 6.0,ASP and now working with ASP.NET(C#/VB.NET),SQL Server 2008/2012 and Reporting Services.

His hobbies include digital photography and watching documentary TV channel.

Syed M Hussain

Web Developer

United Kingdom

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

Ullas_Krishnan

India

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

Vadim Stadnik

Software Developer (Senior)

Australia

Vadim Stadnik has many years of experience of the development of innovative software products. He is the author of the book “Practical Algorithms on Large Datasets”, available on Amazon. His interests include computational mathematics, advanced data structures and algorithms, artificial intelligence and scientific programming.

voloda2

Team Leader NCR

Czech Republic

I'm software developer since 1996. I started with assembler on Intel 8051 CPUs, during years I was interested in C, C++, Sybase PowerBuilder, PHP, Sybase Anywhere Database, MSSQL server and multiplatform development.

Currently I'm developing in C++ and C# (this is my favorit and I spent some time with MCPD achievement). I'm also interested in design patterns.

First Prize	Mohd Manzoor Ahmed - ASP.NET MVC Web App on 3-Tier for Beginners – Part 1
Prize pool	CodeProject T-Shirt - CodeProject


Second Prize	Khademul Basher - Single Page Application using AngularJS and Web API and Responsive using Bootstrap.
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.