Database helper. All database (sqlite) calls can go in here. * @author Muhammad Riyaz. Public class DBHelper {. Private static final String DB_NAME = 'db_name'. Private static final int DB_VER = 1. Private static final String TAG = DBhelper.class.getSimpleName(). // table names. Private static final String. Public class DBHelper extends java.lang.Object SmartStore Database Helper Singleton class that provides helpful methods for accessing the database underneath the SmartStore It also caches a number of of things to speed things up (e.g. Soup table name, index specs, insert helpers etc).

• • • Introduction This document covers 1. Overview of DbProviderFactory [in the Background section] 2.

DBHelper class to implement DbProviderFactory concepts 3. Pre-requisites for DBHelper class 4. Overview of DBHelper class In addition, this include source codes for 1. DBHelper class 2. EmployeeDL [DataLayer class] with the implementation Background Since DotNet evolved, ADO.Net have been getting improvized by trying different approaches. To communicate with different databases ADO.Net have been providing a set of numerous data providers which can be readily accessed under the “System.Data” namespace.

For example SQL Server - System.Data.SqlClient Oracle - System.Data.OracleClient OleDb - System.Data. OleDb Odbc - System.Data.

Odbc etc In the real world scenario, there are chances of changing databases. Oracle Virtual Directory Installation Guide 11g Amendment. As per the current situation, developers use to write code based on a specific data provider, say SQL.

But if the database has to be changed to Oracle, the code must be rewritten to support the Oracle data provider, which is really tedious. To overcome this situation ADO.Net has come up with a generic solution by providing a new namespace under “System.Data” which is “System.Data.Common”.

Generalized versions of all data providers are available under this namespace, namely • DbCommand • DbCommandBuilder • DbConnection • DbDataAdapter • DbDataReader • DbException • DbParameter • DbTransaction Using the code DBHelper Class DBHelper class is created with the intension to reduce the coding effort by using the DbProvider Factory concepts. This class provides a set of methods for • ExecuteNonQuery • ExecuteScalar • ExecuteReader • DataAdapter Pre-requisites Dot Net 2.0 Settings The Web.config file should be having the following keys in the appSettings section. // Include the lines in the Web.config file with the required details with opening and closing tags add key= ' DATA.PROVIDER' value= ' System.Data.SqlClient' add key= ' DATA.CONNECTIONSTRING' value= ' data source=ServerName;initial catalog =DatabaseName; user id =UserId; pwd =Password;' DATA.PROVIDER - To define the Provider. DATA.CONNECTIONSTRING - To define the Connection string. Overview of DBHelper class Below mentioned are some of the methods available in the DBHelper class.