Sql CE Helper类

class SqlCeHelper : IDisposable
    {
        private SqlCeConnection connection;
        private SqlCeCommand command;
        private const string connectionString = “Data Source=/DB/db.sdf“;

        #region Open/Close
        public void Open（）
        {
            try
            {
                connection = new SqlCeConnection（connectionString）;
                command = connection.CreateCommand（）;
                command.Connection = connection;
                command.CommandType = CommandType.Text;

                connection.Open（）;
            }
            catch （DataException e）
            {
                Console.WriteLine（e.Message）;
            }
        }

        public void Close（）
        {
            connection.Close（）;
            connection.Dispose（）;
        }

        public void Dispose（）
        {
            connection.Close（）;
            connection.Dispose（）;
            command.Dispose（）;
        }
        #endreg