DataBase with Extension SDF

 using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlServerCe;
using System.Data;
 
namespace SQL
{
    class SQLCe
    {
        #region---Class Members---
        SqlCeConnection _Connection;
        SqlCeCommand _Command;
        #endregion
 
        #region ---Constructor---
        internal SQLCe()
        {
            _Connection = new SqlCeConnection();
            _Command = (SqlCeCommand)this.NewCommand();
        }
        #endregion
 
        #region Members
 
        public IDbConnection Connection
        {
            get
            {
                return _Connection;
            }
        }
        public IDbDataAdapter CreateAdapter(string SelectCommand)
        {
            return new SqlCeDataAdapter(SelectCommand, (SqlCeConnection)this.Connection);
        }
        public string ConnectionString
        {
            get
            {
                return _Connection.ConnectionString;
            }
            set
            {
                _Connection.ConnectionString = value;
            }
        }
 
        public void Connect()
        {
            _Connection.Open();
        }
 
        public void Connect(string ConnectionString)
        {
            this.ConnectionString = ConnectionString;
            _Connection.Open();
        }
 
        public void Disconnect()
        {
            _Connection.Close();
        }
 
        public void ReConnect()
        {
            _Connection.Close();
            _Connection.Open();
        }
 
        public void BeginTran()
        {
            NewCommand("begin tran").ExecuteNonQuery();
        }
 
        public void CommitTran()
        {
            NewCommand("commit tran").ExecuteNonQuery();
        }
 
        public void RollBack()
        {
            NewCommand("rollback").ExecuteNonQuery();
        }
 
        public void PopulateDataTable(DataTable DataTable, string Select)
        {
            PopulateDataTable(DataTable, NewCommand(Select));
        }
 
        public void PopulateDataTable(DataSet DataSet, string Select)
        {
            PopulateDataTable(DataSet, NewCommand(Select));
        }
 
        public void PopulateDataTable(DataSet DataSet, IDbCommand Select)
        {
            SqlCeDataAdapter Adp = new SqlCeDataAdapter((SqlCeCommand)Select);
            Adp.Fill(DataSet);
        }
 
        public void PopulateDataTable(DataTable DataTable, IDbCommand Select)
        {
            SqlCeDataAdapter Adp = new SqlCeDataAdapter((SqlCeCommand)Select);
            Adp.Fill(DataTable);
        }
 
        public IDbCommand NewCommand()
        {
            return NewCommand("");
        }
        public IDbCommand NewCommand(string Command)
        {
            return new SqlCeCommand(Command, this._Connection);
        }
        public int ExecuteNonQuery(IDbCommand Command)
        {
            return Command.ExecuteNonQuery();
        }
        public object ExecuteScalar(IDbCommand Command)
        {
            return Command.ExecuteScalar();
        }
        public void SetAdaptertInsertCommand(string Query, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).InsertCommand = (SqlCeCommand)NewCommand(Query);
        }
        public void SetAdaptertUpdateCommand(string Query, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).UpdateCommand = (SqlCeCommand)NewCommand(Query);
        }
        public void SetAdaptertDeleteCommand(string Query, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).DeleteCommand = (SqlCeCommand)NewCommand(Query);
        }
 
        public void SetAdaptertInsertCommand(IDbCommand Query, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).InsertCommand = (SqlCeCommand)Query;
        }
        public void SetAdaptertUpdateCommand(IDbCommand Query, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).UpdateCommand = (SqlCeCommand)Query;
        }
        public void SetAdaptertDeleteCommand(IDbCommand Query, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).DeleteCommand = (SqlCeCommand)Query;
        }
 
        public IDbCommand GenerateInsertCommand(IDataAdapter Adapter)
        {
            SqlCeCommandBuilder builder = new SqlCeCommandBuilder((SqlCeDataAdapter)Adapter);
            return builder.GetInsertCommand(false);
        }
        public IDbCommand GenerateUpdateCommand(IDataAdapter Adapter)
        {
            SqlCeCommandBuilder builder = new SqlCeCommandBuilder((SqlCeDataAdapter)Adapter);
            return builder.GetUpdateCommand(false);
        }
        public IDbCommand GenerateDeleteCommand(IDataAdapter Adapter)
        {
            SqlCeCommandBuilder builder = new SqlCeCommandBuilder((SqlCeDataAdapter)Adapter);
            return builder.GetDeleteCommand(false);
        }
 
        public void UpdateAdapter(DataTable Table, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).Update(Table);
        }
 
        public void UpdateAdapter(DataSet DataSet, IDataAdapter Adapter)
        {
            ((SqlCeDataAdapter)Adapter).Update(DataSet);
        }
        #endregion
    }
}

"DataSource = {0};Encrypt=True ;pwd = {1}";