C# (CSharp) CompositePrimaryKeyStatement.CreateStatement Exemples

Exemple #1

        public void CreateStatementWithOneKeyTest()
        {
            const string keyMember1 = "keyMember1";

            var primaryKeyStatement = new CompositePrimaryKeyStatement(new List <string> {
                keyMember1
            });

            Assert.AreEqual(primaryKeyStatement.Count, 1);
            Assert.AreEqual(primaryKeyStatement.CreateStatement(), "PRIMARY KEY(keyMember1)");
        }

Exemple #2

Fichier : PrimaryKeyStatementTest.cs Projet : msallin/SQLiteCodeFirst

        public void CreateStatementWithTwoKeyTest()
        {
            const string keyMember1 = "keyMember1";
            const string keyMember2 = "keyMember2";

            var primaryKeyStatement = new CompositePrimaryKeyStatement(new List <string> {
                keyMember1, keyMember2
            });

            Assert.AreEqual(primaryKeyStatement.Count, 2);
            Assert.AreEqual(primaryKeyStatement.CreateStatement(), "PRIMARY KEY([keyMember1], [keyMember2])");
        }