Click here to Skip to main content
14,575,143 members

Best Database Article of April 2016

This competition has ended

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.

19 Apr 2016
Dave Kerr
If you are looking to get your hands dirty and learn all about Docker, then look no further!
27 Apr 2016
Daniel Joubert
Comparing Requirements Engineering for Traditional and BigData Business Intelligence
18 Apr 2016
Ankita 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.
21 Apr 2016
Emmanouil Gimissis MSc ICSD
Calculating progressive sums in
1 Apr 2016
Akhil 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.
11 Apr 2016
VijayRana
MongoDB Tutorial - MongoDB specific queries
5 Oct 2016
Sahil 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.
18 Apr 2016
VijayRana
MongoDB Tutorial - Day 3 (Performance - Indexing)
10 May 2016
Florian Rappl
In the second part we learn about generics, Lambda expressions, Extension methods and GUI programming.
4 Apr 2016
Khademul Basher
Web service security using bearer Token with Postman as a client application and Web API as server side.
14 Apr 2016
Akhil Mittal
In this article I’ll explain how we can host aWebAPI in another process independent of IIS.
19 May 2017
Yuriy Magurdumov
Two flavors of IDataReader implementations used together with SqlBulkCopy to insert static and dynamic data structures into SQL Server table.
6 Apr 2016
Sharad 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.
12 Apr 2016
Shao Voon Wong
How to prevent SQL injection attacks when using dynamic SQL in stored procedures
6 May 2016
Riccardo Cervelli
Sample for custom entity data model and jSon query with SqlServer 2016
28 Apr 2016
Sharad Chandra Pyakurel
Generic repository application of employee with documents
6 Sep 2016
Mahmoud Samir Fayed
Free Open Source Innovative and practical general-purpose multi-paradigm Scripting language developed using C/C++
8 Apr 2016
Keyhole Software
Seriate: The Glue Between SQL Server and Node.js
11 Apr 2016
Serge V. Sushko
SQLite access C++ classes
16 May 2016
Md._Mehedi_Hasan
This tip will help you to generate .xml file in AngularJs and ASP.NET MVC5 using XElement of C#.
3 Apr 2016
S Ravi Kumar (TechieRathore)
Simple POCO N SQL Generator in C#
2 Apr 2016
SantanuDebnath
Write one SP for multiple Search
1 Apr 2016
B. 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
9 May 2016
Pawel Sienko
The open source lightweight library to generate random values for string, float, date, double and decimal.
10 Apr 2016
Abhinav Kumar singh (Aman)
Learn an interesting way to design database with coder's perspective
12 Apr 2016
Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table
17 Apr 2016
Alex_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.

Current Participants

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

Akhil Mittal
Architect https://codeteddy.com/
India India
Akhil Mittal is an Ex-Microsoft MVP(Most Valuable Professional), C# Corner MVP, Codeproject MVP, a blogger, author and likes to write/read technical articles. Akhil has an experience of around 12 years in developing, designing, architecting enterprises level applications primarily in Microsoft Technologies. Akhil enjoys working on technologies like MVC, Web API, Entity Framework, Angular, C# and BlockChain. Akhil is an MCP( Microsoft Certified Professional) in Web Applications (MCTS-70-528, MCTS-70-515) and .Net Framework 2.0 (MCTS-70-536). Visit Akhil Mittal’s personal blog CodeTeddy for some good and informative articles.
LinkedIn: https://www.linkedin.com/in/akhilmittal/
Group type: Collaborative Group

770 members

No Biography provided
Alex_2979
Russian Federation Russian Federation
No Biography provided
Ankita Biswas Bhattacharya
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.
Aqeeel
Software Developer
Pakistan Pakistan
No Biography provided
B. Clay Shannon
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
Daniel Joubert
Architect
South Africa South Africa
I a software development manager with 20 years of experience building enterprise systems. I have a passion working with people and technology, this ensure that the software created is working as expected and on time.

I love the outdoors, especially with my wife and children.

I have a master's degree in phycology and I am busy with my master's degree in computer science.
Dave Kerr
Software Developer
United Kingdom United Kingdom
Follow my blog at www.dwmkerr.com and find out about my charity at www.childrenshomesnepal.org.
Emmanouil Gimissis MSc ICSD
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.
Florian Rappl
Chief Technology Officer
Germany Germany
Florian lives in Munich, Germany. He started his programming career with Perl. After programming C/C++ for some years he discovered his favorite programming language C#. He did work at Siemens as a programmer until he decided to study Physics.

During his studies he worked as an IT consultant for various companies. After graduating with a PhD in theoretical particle Physics he is working as a senior technical consultant in the field of home automation and IoT.

Florian has been giving lectures in C#, HTML5 with CSS3 and JavaScript, software design, and other topics. He is regularly giving talks at user groups, conferences, and companies. He is actively contributing to open-source projects. Florian is the maintainer of AngleSharp, a completely managed browser engine.
Keyhole Software
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.
Group type: Organisation

3 members

Khademul Basher
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
No Biography provided
Mayur V Lohite
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
Md._Mehedi_Hasan
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.
Pawel Sienko
Poland Poland
No Biography provided
Riccardo Cervelli
Software Developer (Senior) Vitrociset
Italy Italy
No Biography provided
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/
Sahil Saini @ Software Developer
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.
SantanuDebnath
Software Developer (Senior) TULI eServices Pvt Ltd
India India
Working as a Sr Dot Net Developer with 7 years experience.
Serge V. Sushko
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
Shao Voon Wong
Software Developer (Senior)
Singapore Singapore
Shao Voon is from Singapore. CodeProject awarded him a MVP in recognition of his article contributions in 2019. In his spare time, he prefers to writing applications based on 3rd party libraries than rolling out his own. His interest lies primarily in computer graphics, software optimization, concurrency, security and Agile methodologies.

You can reach him by sending a message on CodeProject or at his Coding Tidbit Blog!
Sharad Chandra Pyakurel
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.
Simon M Li
China China
I am C++ developer with 14 years experience. I am good at native programming and debugging. I am studying .net now.
VijayRana
Technical Lead
India India
Hi Myself Vijay having around 7 years of experience on Microsoft Technologies.
Yuriy Magurdumov
Architect
United States United States
No Biography provided

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