setupforeignkey.cs

来自「Microsoft Mobile Development Handbook的代码」· CS 代码 · 共 35 行

using System;
using System.Data.SqlServerCe;
using System.IO;
using System.Reflection;

namespace MobileDevelopersHandbook
{
    class SetupForeignKey
    {
        public static void DefineKey()
        {
            // Setup the connection string
            string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase);
            string connString = "Data Source=" + databasePath + 
                "\\MyDatabase.sdf; Password=MobileP@ssw0rd";

            string commandText = "ALTER TABLE Product " +
                "ADD CONSTRAINT Product_ProductCategory_FK " +
                "FOREIGN KEY (ProductCategoryID) REFERENCES ProductCategory(ProductCategoryID) " +
                "ON DELETE CASCADE " +
                "ON UPDATE CASCADE";

            using (SqlCeConnection conn = new SqlCeConnection(connString))
            {
                using (SqlCeCommand cmd = new SqlCeCommand(commandText, conn))
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    conn.Close();
                }
            }
        }
    }
}