SQL Server Compact 有哪些限制 （或者 - 如何选择在 MS 平台上使用的数据库）

### SQL Server Compact 限制及数据库选择指南

csharp
using System;
using System.Data.SqlServerCe;
namespace SQLCompactExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source = MyDatabase.sdf; Password = myPassword";
            
            using (SqlCeEngine engine = new SqlCeEngine(connectionString))
            {
                engine.CreateDatabase();
                using (SqlCeConnection connection = new SqlCeConnection(connectionString))
                {
                    connection.Open();
                    string createTableQuery = "CREATE TABLE MyTable (ID INT, Name NVARCHAR(50))";
                    using (SqlCeCommand command = new SqlCeCommand(createTableQuery, connection))
                    {
                        command.ExecuteNonQuery();
                        Console.WriteLine("Table created successfully!");
                    }
                    connection.Close();
                }
                engine.Dispose();
            }
        }
    }
}