Click here to Skip to main content
14,578,796 members


Great Reads

by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
by Martin Vorbrodt
SQL database access

Latest Articles

by CodingKnight
While you don’t need to know about the details of Bytecode and JVMs to qualify as a Java programmer, such knowledge is still very beneficial.
by DiponRoy
Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.
by DiponRoy
Select data as DataTable object for a database using Entity Framework

All Articles

Sort by Updated


6 Dec 2016
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
3 Jul 2012
Dynamic data retrieval from Oracle database to Excel sheet based on a parameter from Excel cell value
27 May 2019
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
5 Apr 2020
Select data as DataTable object for a database using Entity Framework
25 Feb 2014
Shivprasad koirala
This article will discuss about 11 important database designing rules.
5 Mar 2014
Shivprasad koirala
Steps to use a logging utility in your projects using Application Blocks.
1 Apr 2009
Ahmet Göktaş
T-SQL string maker for backup with a MEDIAPASSWORD database.
20 Dec 2010
Albin Abel
Simple Pattern Matching Technique for Search Suggest Boxes
17 Apr 2016
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.
4 Dec 2013
Alexander Iskhakov
A comparison Entity Framework 5 and NHibernate 3.3 on a real-world .NET application with Oracle 11g.
20 Mar 2017
A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database.
9 Dec 2010
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
1 Feb 2012
Ashish Tripathi
DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel.
24 Apr 2019
Azim Zahir
This article demonstrates Data Visualization using Matplotlib library of Python.
20 Dec 2018
Benktesh Sharma
An illustration of working with Map/Reduce paradigm in the NetSuite cloud.
29 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
1 Jan 2011
Bibhas Paul
Interaction between C# application and Oracle through custom Object
27 Jan 2010
Bibhas Paul
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
18 Oct 2013
Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
5 Jan 2018
Brien M. Posey
In this article, we compare the object storage offerings of each of these cloud providers.
3 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
18 Oct 2010
This article gives you an overview of how you can quickly develop .NET applications using the pragmatic CodeFluent Entities software factory. This tool generates ready-to-use components from a simple model and provides you multiple out-of-the box architecture options.
13 Feb 2012
Chinthala Upender
Bouncy Castle provide encrypt/decrypt your personal data such as password, SSN, credit card numbers etc. using Simple JASYPT framework.
13 Nov 2008
An article explaining how to list oracle data sources from tnsnames.ora file
11 Apr 2015
Database Star
This article explains how to download and install Oracle Express and SQL Developer on your own computer, to get started with running SQL queries.
17 Jul 2017
Database Star
This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.
22 May 2014
A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid
22 May 2014
A three-part series demonstrating how to develop an Oracle Call Interface (OCI) custom data source for Ultimate Grid
15 Jun 2007
Take a snapshot of the main Window of any UI application
26 Jul 2017
Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
1 Oct 2013
Espen Harlinn
A reflection based wrapper for the Oracle Data Provider for .NET – allows your application to dynamically load the Oracle.DataAccess.dll assembly installed on your client’s computer.
13 Apr 2014
Espen Harlinn
Enhance productivity and reliability, write your own tools.
24 Apr 2014
This article helps developer to start working with new mobile application development framework Oracle ADF Mobile.
9 Oct 2016
Farhad Jabiyev
One of the most popular questions is whether there exists a method which will automatically decide whether to insert, update or delete entity in the Entity-Framework. Now it is possible with EntityGraphOperations library.
8 Nov 2005
How to do full text search with Oracle Text
19 Sep 2013
Details using an ORM model to provide a common facade to multiple disparate databases.
19 Apr 2013
Girish Yerzal
This article will definitely give you a brief idea about cursor with examples.
25 Oct 2008
Guy Haim
A Graphic tool for Oracle developers and DBAs
8 Aug 2013
An approach using updatable views with check option and deferred constraint checking.
29 Jul 2013
The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.
3 Jan 2013
Alternative tnsping for Oracle Instant Client.
9 Jun 2009
How to return multiple ref cursors from Oracle using DAAB
25 Apr 2013
In the Face of God
Unmanaged code application accessing data in a database via Web Services without a database provider.
19 Apr 2017
Intel Corporation
This article introduces BigDL, shows you how to build the library on a variety of platforms, and provides examples of BigDL in action.
13 May 2011
J Chandra Sekhar Achary
Useful tips for Oracle import/export to address constraint issues.
15 Mar 2013
Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
1 Mar 2016
Jörgen Andersson
Fluent database access
26 Jan 2016
Jörgen Andersson
A propertymapping extension for DataReaders
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
22 Jun 2009
Kuldip Rindani
This script calculates size of every user database with summary
18 Apr 2011
Manuel Vidigal
An implementation of the Longest Common Subsequence (LCS) diff algorithm in PL/SQL.
16 Aug 2019
Marijan Nikic
An HTML tool written in JavaScript to convert a regular Oracle SQL query into a spooling script
26 Sep 2018
An example on how to call Oracle stored procedures with UDTs from ASP.NET MVC / REST API
2 Mar 2015
Kerosene ORM support for complete database-alike WCF services and connections
1 Mar 2015
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
1 Mar 2015
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
1 Mar 2015
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
11 Mar 2014
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
1 Feb 2018
Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
21 Dec 2017
Miguel Diaz Kusztrich
A database tool for search text in procedures, views and tables using regular expressions
16 Jun 2009
Mike Lang
A data abstraction layer for .NET applications. Write your application code to be database neutral. Swap out the type of database your application uses without updating or even recompiling your business components.
13 May 2009
Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
1 Dec 2009
Murali Manohar Pareek
ASP.NET Gridview with Default and Custom Paging, Sorting, Export Data, Freeze Header, Column Resizing, Row Hover, Row Selection, Grid Cell Tooltip features for better Performance, functionality and GUI with Oracle Database
6 Mar 2012
This article introduces the steps to create a report with a custom search area.
29 Oct 2013
Ogwara Rowland
NW.ORM, a helper framework for working Hibernate.
29 Sep 2014
Omar Al Zabir
Oracle Performance Dashboard (OPD) is a small ASP.NET website that shows you performance & problems of one or more Oracle instances in near real-time. It uses the Dynamic Performance Views (DPV) and runs some popular DBA scripts in order to get meaningful, easy to understand information out of the s
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
7 Oct 2016
Paulo Uechi
Uechi APM Web is an APM (Application Performance Management) Open Source Server Performance Monitor written and developed in Java and C # for all Linux and Windows platforms. The Uechi.APM.Web offers a complete resource for unlimited monitoring servers in real time. Have full control of the CPU cons
18 Jan 2014
Petr Ivankov
Application of abstract approach to database domain
9 May 2012
Petr Ivankov
Long time strategy of software design and development
30 Aug 2010
Petr Kozelek
Logging of data changes in relational databases
10 Nov 2011
Phani Krishna Kollapur Gandla
Migration of Relational Data structure to Cassandra (No SQL) Data structure
10 Nov 2011
Phani Krishna Kollapur Gandla
How to solve performance issues in data migration to SQL Server.
3 Apr 2013
Pierre Kellerman
Explaining different ways to join tables
30 Jan 2018
Quest Software
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
24 Apr 2019
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
27 May 2016
Rednet Software
Rednet.DataAccess is yet another component to work with data that simplifies your use.
22 Feb 2011
The article is to introduce a utility to generate cascading delete script for an Oracle table.
5 Sep 2015
Sadique KT
How to Install Oracle 12c, How to create listener, How to create TablesSpaces and How to restore database
3 Mar 2011
This article briefs about different types of PL/SQL collections, their advantages, how to pass an array to stored procedure from ASP.NET application, etc.
31 Oct 2016
EF implementation of BulkInsert operation and "Arrays in a Bind" solution at case of absence of EF.
22 Nov 2011
Oracle 11g Report Installation on RedHat Linux 5x
3 Dec 2011
Oracle database 11g release 2 installation on suse and Enterprise Linux
29 Mar 2009
Steve MunLeeuw
Embedding the content of a PDF document is not supported, but we can add this feature with a SQL CLR function to parse the PDF into a list of images.
11 Jul 2008
Syed M Hussain
This is a very simple tool, to query an Oracle XE database
5 Apr 2009
Tarek Najem
How to delete duplicate entries from a data store, while leaving a single copy.
1 Jan 2009
Learn how to bridge the gap between relational and object designs(models) and increase your productivity using Telerik OpenAccess ORM.
31 Jul 2008
Utility to manage multiple DB connection strings for an application.
5 Feb 2014
First article on creating a reusable framework
30 Oct 2014
Vaclav Naydenov
How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.
20 Aug 2010
Vivek Johari
This article is written to describe all the different types of Sql Joins
28 Aug 2009
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
14 Sep 2011
This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer
1 Apr 2012
The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
19 Mar 2011
How to create custom aggregates in Oracle using PL/SQL
8 Jan 2012
This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
30 Apr 2012
This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
2 Jun 2014
Woong Gyu La
This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"
30 Apr 2009
An open source Data Access Component