может найдешь что - нибудь полезное для себя

using System;
using System.Drawing;
using System.Collections;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlServerCe;

namespace SQLCETesting
{

public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.MainMenu mainMenu1;

public Form1()
{
//
// Required for Windows Form Designer support.
//
InitializeComponent();

//If the file "test.sdf" exists, delete it.
if (System.IO.File.Exists("\\My Documents\\test.sdf"))
System.IO.File.Delete("\\My Documents\\test.sdf");

//Create the new database.
SqlCeEngine engine = new SqlCeEngine("Data Source = \\My Documents\\test.sdf");
engine.CreateDatabase();

//Create a connection to the new database.
SqlCeConnection ssceconn = new SqlCeConnection("Data Source = \\My Documents\\test.sdf");

//Create the createTable command on the connection.
SqlCeCommand createTable = ssceconn.CreateCommand();
createTable.CommandText = "Create TABLE People(people_id int IDENTITY(0,1) PRIMARY KEY, f_name ntext,l_name ntext)";

//Create the insertRow command on the connection.
SqlCeCommand insertRow = ssceconn.CreateCommand();
insertRow.CommandText = "INSERT INTO People(f_name, l_name) VALUES ('John', 'Doe')";

//Open the connection, execute the queries, close the connection.
ssceconn.Open();
createTable.ExecuteNonQuery();
insertRow.ExecuteNonQuery();
ssceconn.Close();

}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.mainMenu1 = new System.Windows.Forms.MainMenu();
//
// Form1
//
this.Menu = this.mainMenu1;
this.MinimizeBox = false;
this.Text = "Form1";

}
#endregion

/// <summary>
/// The main entry point for the application.
/// </summary>

static void Main()
{
Application.Run(new Form1());
}
}
}