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

Best Database Article of March 2014

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.
28 Mar 2014jurhas
Spada via Modbs, Supervisory Control and Data Acquisition with visualb basic,Arduino and firebird
Please Sign up or sign in to vote.
18 Mar 2014Pragmateek
How to reduce the size of MongoDB documents generated from .NET/C#
Please Sign up or sign in to vote.
8 Mar 2014SanSkun
How to bind holiday list and information about those holidays from database
Please Sign up or sign in to vote.
19 Mar 2014Jacob Himes
My go around to an Entity Framework alternative
Please Sign up or sign in to vote.
23 Jun 2019Octavio Sanchez Huerta
Python Script using WSLT
Please Sign up or sign in to vote.
4 Mar 2014Malak Zia Nasir
Cloud computing is the trend of nowadays; this article provides some basic steps to create and connect a Windows Azure SQL Database to a simple application.
Please Sign up or sign in to vote.
9 Mar 2014Davinder Singla
This tip is for solving out of memory issue for large result sets in MyBatis
Please Sign up or sign in to vote.
5 Mar 2014bconlon
XSD 1.1 support in Liquid XML 2014
Please Sign up or sign in to vote.
13 Mar 2014AshakiranBhatter
Understanding FAT file system and kernel programming in C/C++
Please Sign up or sign in to vote.
21 Mar 2014Baxter P
Dependency Injection Data Demo with Lazy Loading and Data Mocking
Please Sign up or sign in to vote.
27 May 2014Shuqian Ying
Implementing a unified structured query system of service based relational data source with build-in intelligence.
Please Sign up or sign in to vote.
11 Mar 2014mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
Please Sign up or sign in to vote.
14 Mar 2014Robert Lindblom
Detecting concurrency issues when using Entity Framework model first and SQL Server
Please Sign up or sign in to vote.
14 Mar 2014Nikita D. Sinelnikov
HowTo: make the report background (elements) of Microsoft .NET Report (.rdlc) non-printable
Please Sign up or sign in to vote.
1 Mar 2015mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
Please Sign up or sign in to vote.
26 Mar 2014Nirav Prabtani
Virtual Expandable Gridview using Ajax post method
Please Sign up or sign in to vote.
18 Mar 2014sankarsan parida
This is developed for using Index, Create, Edit and Delete operations in a Single View Page
Please Sign up or sign in to vote.
11 Mar 2014Er. Puneet Goel
This article is about how to start with MVC. Its very simple and useful article that include basic Save, Update and Delete methods using MVC.
Please Sign up or sign in to vote.
28 Mar 2014adriancs
Simplify the usage between C# and SQLite
Please Sign up or sign in to vote.
7 Jul 2014Code Help 2014
A simple tutorial for beginners to learn the basics of Entity Framework. It will teach you how to perform CRUD operations using EF.
Please Sign up or sign in to vote.
19 Mar 2014Razi Syed
This is an alternative for "EntityUI Automatic UI Generator using CodeFirst Approach"
Please Sign up or sign in to vote.
17 Mar 2014x3F
Batch scripts that help install MongoDB on a Windows PC
Please Sign up or sign in to vote.
24 Mar 2014Arun Ramachandran India
ADO.NET – How to call a stored procedure with output parameters?
Please Sign up or sign in to vote.
28 Mar 2014Romain Gailleton
A presentation on how to extract data from a Type Library (.tlb) and access COM Binary Interface from C++ using Qt
Please Sign up or sign in to vote.
14 Mar 2014Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
Please Sign up or sign in to vote.
28 Mar 2014Kinyanjui Kamau
Being able to add or update data field by field through Winforms using EF5, .NET 4.5
Please Sign up or sign in to vote.
31 Mar 2014Darek Danielewski
With a little help from C# Extensions and Dapper, it is easy to streamline coded database interaction, even with encrypted columns
Please Sign up or sign in to vote.
16 Mar 2014Dinesh K.S. Kushwaha
Tip on CROSS APPLY and OUTER APPLY
Please Sign up or sign in to vote.
20 Jun 2021Elisha Cornelius
Recover SQL Script files that are lost due to SSMS Crash or whatever the other reasons
Please Sign up or sign in to vote.
25 Mar 2014Bibhu Dutta
Using MongoDB with C#
Please Sign up or sign in to vote.
24 Mar 2014Keyhole Software
Encapsulation approach to bring data sources and implementations closer together, allowing reflection-like behavior in a format that mere mortals can read.
Please Sign up or sign in to vote.
28 Mar 2014derekman9707
SSIS - Do I Union All or Merge?
Please Sign up or sign in to vote.
14 Mar 2014nitinnigam21
This article will allow you to move your database from SQL Server to SQL Azure to enhance the performance of your application that has been deployed on the Azure Cloud.
Please Sign up or sign in to vote.
7 Mar 2014Nitinpatel
This SQL script will generate a script to drop and create all foreign keys in database.
Please Sign up or sign in to vote.
24 Mar 2014Christian Graus
Covering how to use the new Distribution functions in SQL Server 2012

Current Participants

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

Team Leader eInfochips
India India



Nirav Prabtani




I am a team lead, Database Architect and Designer /Technical Architect/Analyst,
Programmer in Microsoft .NET Technologies & Microsoft SQL Server with more than
4.5 years of hands on experience.



I love to code....!!! Smile | :)



My recent past includes my work with the education domain as a technical business
requirement analyst, database architect & designer and analyst programmer; just
love my involvement with the world of knowledge, learning and education and I think
I know quite well what I want to do in life & in my career. What do I like? Well,
ideation, brainstorming, coming up with newer and more creative ways of doing things;
each time with an enhanced efficiency. An item in my day's agenda always has a task
to look at what I did yesterday & focus on how I can do it better today




Contact Me

Nirav Prabtani


Mobile : +91 738 308 2188



Email : niravjprabtani@gmail.com


My Blog:
Nirav Prabtani


Software Developer
Other Other
Programming is an art.
Software Developer
India India
Arun Ramachandran is a Software Engineer having hands on experience in different Microsoft Technologies who is presently working in Experion Technologies, India. He has written over 95 articles on the subject on his blog at http://BestTEchnologyBlog.com. Along with 3 years of hands on experience he holds a Master of Computer Applications degree from Cochin University of Science & Technology (CUSAT).
Software Developer
United States United States
Ashakiran is from Hyderabad, India and currently working as a Software Engineer in USA. He is a hobbyist programmer and enjoys writing code.
Software Developer
United Kingdom United Kingdom
I am a software developer working with Microsoft technologies since 2000.

Skills include C/C++, C#, VB.NET, MS SQL Server, ASP.NET Webforms/MVC, AngularJS, NodeJS, Sharepoint Development, WPF, WCF, Winforms, plus others.
Software Developer
United Kingdom United Kingdom
Software developer and geek with 20 years coding experience mainly C++, C#, XML.
Please visit my developer blog: http://geekswithblogs.net/bconlon/Default.aspx
Software Developer Mindfire Solutions
India India
Software developer, working at Mindfire Solutions, having hands on experience in both Windows and web application using C#, ASP.NET, ASP.NET MVC.
Software Developer (Senior)
Australia Australia
Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.
Software Developer (Senior)
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Architect BI Software, Inc.
United States United States
A seasoned IT Professional. Programming and data processing artist. Contributor to StackOverflow.
Architect
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Database Developer
United States United States
David retired as a Sergeant with the Cape Coral Police Department after 22 years of service. His final 10 years of duty were as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to Administrative Services in 2002 and was responsible for database administration, software integration, and development for public safety. David’s primary focus and expertise is with SQL Server, reporting services, integration services, and analysis services, and he was recognized for his work by SQL Server Magazine as “Innovator of the Year” runner up in 2007. David is an MCITP for SQL Server 2005 and 2008 in both database administration and business intelligence and is a Microsoft Certified Trainer. He regularly posts on the MSDN SQL Server forums where he also serves as a moderator, and is a contributor at SQLCLR.net. In addition to his knowledge of SQL Server David works as a software developer using VB.net and C# and has worked extensively in SharePoint development.
Team Leader Kochar Infotech Pvt. Ltd.
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Chief Technology Officer
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
India India
Puneet Goel is an IT Professional with 8+ years. He is specialized in Microsoft Technologies (Asp.NET, SQL Server, Ajax, Jquery, JavaScript, MVC, and Angular). He is an avid member of several development communities and a serial blogger.He loves to learn new technology, do experiments with existing ones, and always happy to help the community.
Software Developer
United States United States
Jacob is an innovative software engineer with a proven track record in creating viable complete software solutions from complex problems quickly and effectively. Possesses a tremendous passion for discovering and taking advantage of absolute cutting edge technology the IT world offers, and applying novel solutions while adhering to traditional best practices. Demonstrates a strong background in enterprise business software, and coordinating complex initiatives.
Italy Italy
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
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
Software Developer (Senior) GetNet
Kenya Kenya
http://www.kinyanjuikamau.com
CEO
Philippines Philippines
Old profile
Spain Spain
mbarbac has worked in start-ups, multinational tech companies, and consulting ones, serving as CIO, CTO, SW Development Director, and Consulting Director, among many other roles.

Solving complex puzzles and getting out of them business value has ever been among his main interests - and that's why he has spent his latest 25 years trying to combine his degree in Theoretical Physics with his MBA... and he is still trying to figure out how all these things can fit together.

Even if flying a lot across many countries, along with the long working days that are customary in IT management and Consultancy, he can say that, after all, he lives in Spain (at least the weekends).
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.
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.
Database Developer
United Kingdom United Kingdom
With 10 years of experience of working on Microsoft platform, currently I am working as Database/BI expert.
Software Developer (Senior) Banco Monex
Mexico Mexico
My interest is in academic research and trying to keep me in the field to obtain a PhD degree, welling on the way to combine a job in a company with the activity I enjoy.
Instructor / Trainer Pragmateek
France (Metropolitan) France (Metropolitan)
To make it short I'm an IT trainer specialized in the .Net ecosystem (framework, C#, WPF, Excel addins...).
(I'm available in France and bordering countries, and I only teach in french.)

I like to learn new things, particularly to understand what happens under the hood, and I do my best to share my humble knowledge with others by direct teaching, by posting articles on my blog (pragmateek.com), or by answering questions on forums.
Software Developer (Senior)
United States United States
My area of expertise is developing management database systems for business so that they can efficiently store and lookup existing customer's information and related data, and be able to generate various reports. My goal is to always deliver innovative design and a user friendly interface.
Software Developer (Senior)
Sweden Sweden
Working as an independent software contractor, specializing in .Net technologies.
Engineer
France France
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Software Developer
India India
Hi all,I am Sankarsan Parida,I am working as a Software Engineer in CTS Kolkata. I have around 4 years of experience in developing the web applications. My areas of interest are C#.Net, Ajax, Sql server, MongoDB, MVC, WCF
Software Developer
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Founder CryptoGateway Software Inc.
Canada Canada


His interests in software research and development include security, domain specific meta-language development technologies and tools, meta-language driven code generation, generation of non-invasive and virtual SQL database for "un-structured" data (sqlization), automated relational data service production technologies, file system sqlization technologies and products, structured multi-lingual documentation tools and technologies, sqlization of user's personal data, like emails, etc..


He was a physicist before year 2000. He studied theoretical physics (the hidden symmetry between the past and future, quantum field theories, mirror universe, cosmological dark energies etc.) in which he think to had made fundamental breakthroughs[^] but the community is either not ready for it or is actively rejecting/ignoring it Smile | :) .



It struck me on Apr. 11, 2023 that the said theory above can even generate General Relativity naturally after a recent discussion in the Insider News group that triggers a rethinking of the subject on my side. The first stage of the work is completed in Sept. 2023, it is and will be continue to be published online

  • On Vacuum
  • Quantum and Gravity







    Most recent software system to share:



    • V-NET[^] - Full stack virtualization management system including networking, storage, virtual machines and containers, with an emphasis on networking ... to be released.
x3F
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. Multiple votes from the same IP will be automatically disqualified.
  11. The judges’ decision is final and no correspondence will be entered into.
  12. Only those who live in jurisdictions in which this contest is legal may enter.
  13. Any breach of the rules and the prize will be awarded to the runner up.
  14. 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.
  15. 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 Mar - 31 Mar 2014