使用c#访问microsoft sql server compact （初级）

sql server compact是微软推出的免费嵌入式数据库，可以通过sql server 2005管理器，来连接管理它。

下面是一段简单的访问示例。

using  System;
using  System.Collections.Generic;
using  System.Text;
using  System.Data.SqlServerCe;
using  System.IO;
using  System.Data;

namespace  ConsoleApplication8
{
     class  Program
    {
         static   void  Main( string [] args)
        {
             string  ceDataFilePath  =  Path.Combine(AppDomain.CurrentDomain.BaseDirectory,  " firstSqlServerCe.sdf " );
             const   string  CONN_STRING  =   " Data Source=firstSqlServerCe.sdf;encryption mode=platform default;Password=2654; " ;

             if  ( ! File.Exists(ceDataFilePath))
            {
                
                 using  (SqlCeEngine engine  =
                     new  SqlCeEngine(CONN_STRING))
                {
                    engine.CreateDatabase();
                }


                 using  (SqlCeConnection conn  =   new  SqlCeConnection(CONN_STRING))
                {
                    conn.Open();
                     using  (SqlCeCommand comm  =   new  SqlCeCommand( " create table test(col1 INT,col2 NVARCHAR(100)) " , conn))
                    {
                        comm.ExecuteNonQuery();
                    }

                     using  (SqlCeCommand comm  =   new  SqlCeCommand( " insert into test values(1,'hello 1') " ,conn))
                    {
                        comm.ExecuteNonQuery();
                    }
                }
            }

             using  (SqlCeConnection conn  =   new  SqlCeConnection(CONN_STRING))
            {
                 using  (SqlCeCommand comm  =   new  SqlCeCommand( " select * from test " ,conn))
                {
                    conn.Open();
                     using  (IDataReader rdr  =  comm.ExecuteReader())
                    {
                         while  (rdr.Read())
                        {
                            Console.WriteLine( " {0}\t{1} " ,rdr[ " col1 " ],rdr[ " col2 " ]);
                        }
                    }
                }
            }
            
            Console.Read();
        }
    }
}