public void TableBackedViewDefinitionPropertiesSet() { var definition = new TableBackedViewDefinition(DatabaseObjectName.FromName("v1"), DatabaseObjectName.FromName("t1")); Assert.AreEqual("[dbo].[v1]", definition.Name.Qualified); Assert.AreEqual("[dbo].[t1]", definition.BackingTable.Qualified); }
public void CreateView() { var viewDefinition = new TableBackedViewDefinition(DatabaseObjectName.FromName("v1"), DatabaseObjectName.FromName("t1")); string expected = string.Format("CREATE VIEW [dbo].[v1] AS SELECT * FROM [dbo].[t1]"); string actual = generator.Sql(viewDefinition); Assert.AreEqual(expected, actual); }
public void TableBackedViewDefinitionNullTableName() { var definition = new TableBackedViewDefinition(DatabaseObjectName.FromName("v1"), null); }
public void TableBackedViewDefinitionNullName() { var definition = new TableBackedViewDefinition(null, DatabaseObjectName.FromName("t1")); }