using System;
using System.Data;
using System.Data.Common;
using BLToolkit.Data.Sql.SqlProvider;
using Devart.Data.Oracle;

namespace BLToolkit.Data.DataProvider
{
   public class DevartDataProvider : DataProviderBase
   {
      public override Type ConnectionType
      {
         get { return typeof(OracleConnection); }
      }

      public override string Name
      {
         get { return "Devart"; }
      }

      public override IDbConnection CreateConnectionObject()
      {
         return new OracleConnection();
      }

      public override DbDataAdapter CreateDataAdapterObject()
      {
         return new OracleDataAdapter();
      }

      public override bool DeriveParameters(IDbCommand command)
      {
         var oraCommand = command as OracleCommand;

         if (null != oraCommand)
         {
            try
            {
               OracleCommandBuilder.DeriveParameters(oraCommand);
            }
            catch (Exception ex)
            {
               // Make Oracle less laconic.
               //
               throw new DataException(string.Format("{0}\nCommandText: {1}", ex.Message, oraCommand.CommandText), ex);
            }

            return true;
         }

         return false;
      }

      public override ISqlProvider CreateSqlProvider()
      {
         return new OracleSqlProvider();
      }
   }
}