// Persist library : Persistence layer
// Copyright (C) 2003 Vincent Daron
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License, or (at your option) any later version.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
using System;
using System.Data;
using System.Data.OleDb;
using System.Collections.Specialized;
using Persist.Sql;
namespace Persist.OleDb{
/// <summary>
/// Summary description for MySQLDatabase.
/// </summary>
public class OleDbDatabase : Persist.Sql.RelationalDatabase
{
private string theConnectionString;
public OleDbDatabase():base()
{
}
public override IDbCommand GetNewCommand()
{
System.Diagnostics.Debug.WriteLine("Get new Command");
return new OleDbCommand();
}
protected override IDbConnection GetNewConnection()
{
System.Diagnostics.Debug.WriteLine(">>>>>>>>>> Create a new OleDb Connection ");
OleDbConnection conn = new OleDbConnection(theConnectionString);
conn.StateChange += new StateChangeEventHandler(conn_StateChange);
return conn;
}
public override IDataParameter GetNewParameter(object value,DbType dbType,string name)
{
OleDbParameter parameter = new OleDbParameter();
parameter.DbType = dbType;
if(dbType == DbType.DateTime)
{
parameter.OleDbType = OleDbType.DBDate;
}
parameter.Value = value;
parameter.ParameterName = name;
parameter.Direction = ParameterDirection.Input;
return parameter;
}
public override string ClauseStringForUpdate
{
get
{
return "";
}
}
public override void Init(NameValueCollection properties)
{
base.Init(properties);
// Get user, password and connection string from properties
theConnectionString = properties["ConnectionString"];
if(theConnectionString == null)
throw new Exception("ConnectionString not specified for " + base.Name + " persistent mechanism");
}
private void conn_StateChange(object sender, StateChangeEventArgs e)
{
System.Diagnostics.Debug.WriteLine("CurrentState : " + e.CurrentState + " Old State : " + e.OriginalState);
}
}
}
|