Click here to Skip to main content
15,867,453 members
This competition has ended

Best Database Article of April 2016

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.

Please Sign up or sign in to vote.
19 Apr 2016Dave Kerr
If you are looking to get your hands dirty and learn all about Docker, then look no further!
Please Sign up or sign in to vote.
18 Apr 2016Ankita Biswas Bhattacharya
Here, I will explain how you can work with SQL views in lightswitch and how you can save data on screens which are created on Views.
Please Sign up or sign in to vote.
21 Apr 2016Emmanouil Gimissis MSc ICSD
Calculating progressive sums in T-SQL
Please Sign up or sign in to vote.
17 Apr 2016Alex_2979
A lot of modern Business Intelligence solutions offer to transfer work of analysts to developers or rise technical level of business analysts, make them closer to developers. Instead of it, I advise to consider a solution, which takes information from Database and gives it to business analysts.
Please Sign up or sign in to vote.
1 Apr 2016Akhil Mittal
This is the last article of the RESTful series in which I’ll explain how you can leverage OData capabilities in ASP.NET WebAPI. I’ll explain what OData is and we’ll create OData enabled RESTful services.
Please Sign up or sign in to vote.
11 Apr 2016VijayRana
MongoDB Tutorial - MongoDB specific queries
Please Sign up or sign in to vote.
5 Oct 2016Sahil Saini @ Software Developer
This article starts with creating the project in MVC with using the bootstrap classes to give better look to the UI and controls used on UI.
Please Sign up or sign in to vote.
18 Apr 2016VijayRana
Performance - Indexing in MongoDB
Please Sign up or sign in to vote.
4 Apr 2016Khademul Basher
Web service security using bearer Token with Postman as a client application and Web API as server side.
Please Sign up or sign in to vote.
14 Apr 2016Akhil Mittal
In this article I’ll explain how we can host aWebAPI in another process independent of IIS.
Please Sign up or sign in to vote.
19 May 2017Yuriy Magurdumov
Two flavors of IDataReader implementations used together with SqlBulkCopy to insert static and dynamic data structures into SQL Server table.
Please Sign up or sign in to vote.
6 Apr 2016Sharad Chandra Pyakurel
This tutorial will explain how to develop android app with Xamarin tool provided by visual studio. This post will walk you through creating a small android app related to AddressBook.
Please Sign up or sign in to vote.
29 Apr 2016Mayur V Lohite
Generic Repository Pattern MVC
Please Sign up or sign in to vote.
12 Apr 2016Shao Voon Wong
How to prevent SQL injection attacks when using dynamic SQL in stored procedures
Please Sign up or sign in to vote.
28 Apr 2016Sharad Chandra Pyakurel
Generic repository application of employee with documents
Please Sign up or sign in to vote.
9 Dec 2016Riccardo Cervelli
Redraw database structure to improve productivity
Please Sign up or sign in to vote.
6 Sep 2016Mahmoud Samir Fayed
Free Open Source Innovative and practical general-purpose multi-paradigm Scripting language developed using C/C++
Please Sign up or sign in to vote.
8 Apr 2016Keyhole Software
Seriate: The Glue Between SQL Server and Node.js
Please Sign up or sign in to vote.
11 Apr 2016Serge V. Sushko
SQLite access C++ classes
Please Sign up or sign in to vote.
16 May 2016Md._Mehedi_Hasan
This tip will help you to generate .xml file in AngularJs and ASP.NET MVC5 using XElement of C#.
Please Sign up or sign in to vote.
3 Apr 2016S Ravi Kumar (TechieRathore)
Simple POCO N SQL Generator in C#
Please Sign up or sign in to vote.
2 Apr 2016SantanuDebnath
Write one SP for multiple Search
Please Sign up or sign in to vote.
1 Apr 2016B. Clay Shannon
Save Excel (or other types of) files to SQL Server, then read them out again and make them downloadable via a link on an ASP.NET Web API page
Please Sign up or sign in to vote.
9 May 2016Pawel Sienko
The open source lightweight library to generate random values for string, float, date, double and decimal.
Please Sign up or sign in to vote.
10 Apr 2016Abhinav Kumar singh (Aman)
Learn an interesting way to design database with coder's perspective
Please Sign up or sign in to vote.
12 Apr 2016Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table

Current Participants

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

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect https://codeteddy.com/
India India
Akhil Mittal is two times Microsoft MVP (Most Valuable Professional) firstly awarded in 2016 and continued in 2017 in Visual Studio and Technologies category, C# Corner MVP since 2013, Code Project MVP since 2014, a blogger, author and likes to write/read technical articles, blogs, and books. Akhil is a technical architect and loves to work on complex business problems and cutting-edge technologies. He has an experience of around 15 years in developing, designing, and architecting enterprises level applications primarily in Microsoft Technologies. He has diverse experience in working on cutting-edge technologies that include Microsoft Stack, AI, Machine Learning, and Cloud computing. Akhil is an MCP (Microsoft Certified Professional) in Web Applications and Dot Net Framework.
Visit Akhil Mittal’s personal blog CodeTeddy (CodeTeddy ) for some good and informative articles. Following are some tech certifications that Akhil cleared,
• AZ-304: Microsoft Azure Architect Design.
• AZ-303: Microsoft Azure Architect Technologies.
• AZ-900: Microsoft Azure Fundamentals.
• Microsoft MCTS (70-528) Certified Programmer.
• Microsoft MCTS (70-536) Certified Programmer.
• Microsoft MCTS (70-515) Certified Programmer.

LinkedIn: https://www.linkedin.com/in/akhilmittal/
This is a Collaborative Group

779 members
Russian Federation Russian Federation
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior)
India India
I have more than 4 years of work experience in .Net technology. I have worked extensively in ASP.NET MVC, C#, Entity Framework. I have basic knowledge in Javascript, Jquery, HTML, CSS, SQL. Recently I am exploring Lightswitch 2013. Although I am a software developer by profession but I am a huge fan of Shreya Ghoshal, Lata Mangeshkar, Kishore Kumar, Sonu Nigam, Shantanu Moitra, R D Burman, Salil Choudhury and Madan Mohan Music's.
Software Developer
Pakistan Pakistan
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Founder Across Time & Space
United States United States
I am in the process of morphing from a software developer into a portrayer of Mark Twain. My monologue (or one-man play, entitled "The Adventures of Mark Twain: As Told By Himself" and set in 1896) features Twain giving an overview of his life up till then. The performance includes the relating of interesting experiences and humorous anecdotes from Twain's boyhood and youth, his time as a riverboat pilot, his wild and woolly adventures in the Territory of Nevada and California, and experiences as a writer and world traveler, including recollections of meetings with many of the famous and powerful of the 19th century - royalty, business magnates, fellow authors, as well as intimate glimpses into his home life (his parents, siblings, wife, and children).

Peripatetic and picaresque, I have lived in eight states; specifically, besides my native California (where I was born and where I now again reside) in chronological order: New York, Montana, Alaska, Oklahoma, Wisconsin, Idaho, and Missouri.

I am also a writer of both fiction (for which I use a nom de plume, "Blackbird Crow Raven", as a nod to my Native American heritage - I am "½ Cowboy, ½ Indian") and nonfiction, including a two-volume social and cultural history of the U.S. which covers important events from 1620-2006: http://www.lulu.com/spotlight/blackbirdcraven
Software Developer
United Kingdom United Kingdom
Follow my blog at www.dwmkerr.com and find out about my charity at www.childrenshomesnepal.org.
Technical Lead P GIMISIS SA
Greece Greece
I am a passionate programmer/developer since 1983, especially in distributed and niche applications, using whatever tools suits best for the job. Have vast experience with Microsoft tools and technologies, especially VB (since 1991), SQL Server (since 1997) and .NET (since 2000) but constantly love to learn and develop my skills.
I hold an MSc in Interactive Computer System Design from Loughborough Univ. of Technology UK and various Microsoft certifications.
When I am not developing, I prefer to delve into history, swim/bike and going out.
Keyhole Software
United States 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
Founder http://softwarelandmarks.com/
Bangladesh 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
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Web Developer
India India
My name is Mayur Lohite. I am Programmer and Web Developer also I am Interested in Web Application Security and penetration. From a young age I’ve been fascinated with building web application and breaking it. So I have choose the Information technology as my career and completed the Degree in Information technology.

I’m a interested in operating and design of large-scale web applications/infrastructure and I’m interested in web application security also I am interested in some networking setting up servers, domains experimenting with clouds(well I am not professional at it)

I am a big fan of Anime series (Naruto) and also love to playing games. In the mean time I love to watching movies specially action movies.

Now I’m a white hat penetration tester. bug hunter and all out security freak by profession and passion. I’ve listed many websites Hall of fame e.g. Microsoft, Yahoo, Apple, Adobe
Software Developer
Bangladesh Bangladesh
Worked on ASP.NET MVC, AngularJS, jQuery, T-SQL, LINQ, Kendo UI, SQL Server, Bootstrap. Working on web based application development and fully concentrated on both client side and server side programming.
Poland Poland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer (Senior) Vitrociset
Italy Italy
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect
India 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/
Software Developer Safaltek Softwares
India India
I am working in Safaltek Softwares and has 3+ years of experience in C# .NET,VB6,MVC,SQl and AngularJS.
Software Developer (Senior) TULI eServices Pvt Ltd
India India
Working as a Sr Dot Net Developer with 7 years experience.
Software Developer (Senior) Oxetta
Russian Federation Russian Federation
An independed software vendor developing business applications for various industries. My current project is Oxetta Report Generator, the free reporting engine for C/C++ developers: http://www.oxetta.com
Software Developer (Senior)
Singapore Singapore
Shao Voon is from Singapore. His interest lies primarily in computer graphics, software optimization, concurrency, security, and Agile methodologies.

In recent years, he shifted focus to software safety research. His hobby is writing a free C++ DirectX photo slideshow application which can be viewed here.
Software Developer (Senior) NLIC
Nepal Nepal
I am in profession of an enterprise software development. I have good knowledge in object oriented programming, windows programming, enterprise web application development , mobile app development, and database designing and programming.
China China
I am C++ developer with 14 years experience. I am good at native programming and debugging. I am studying .net now.
Technical Lead
India India
Hi Myself Vijay having around 7 years of experience on Microsoft Technologies.
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Contest Entries and Requirements

  1. 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.
  2. Entries must be an article, or blog entry.
  3. 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).
  4. Articles entries must follow the CodeProject submission guidelines.
  5. No cheating, lying, plagiarizing articles, chicanery, or kicking.
  6. 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.
  7. No author can be nominated twice in the same category.
  8. 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.
  9. 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.
  10. 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.
  11. In the event of a tie, the number of prizes issued is solely at the discretion of the prize issuer.
  12. Multiple votes from the same IP will be automatically disqualified.
  13. The judges’ decision is final and no correspondence will be entered into.
  14. Only those who live in jurisdictions in which this contest is legal may enter.
  15. Any breach of the rules and the prize will be awarded to the runner up.
  16. 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.
  17. 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.

You must sign in to participate in this contest.
This contest has ended.
1 Apr - 30 Apr 2016