internal static string CreateObjectScript(AssociationSet associationSet) { JetCreateDatabaseSqlGenerator builder = new JetCreateDatabaseSqlGenerator(); builder.AppendCreateForeignKeys(associationSet); return(builder.GetCommandText()); }
internal static string CreateObjectsScript(StoreItemCollection itemCollection) { JetCreateDatabaseSqlGenerator builder = new JetCreateDatabaseSqlGenerator(); foreach (EntityContainer container in itemCollection.GetItems <EntityContainer>()) { var entitySets = container.BaseEntitySets.OfType <EntitySet>().OrderBy(s => s.Name); foreach (EntitySet entitySet in container.BaseEntitySets.OfType <EntitySet>().OrderBy(s => s.Name)) { builder.AppendCreateTable(entitySet); builder.AppendSql(";"); } foreach (AssociationSet associationSet in container.BaseEntitySets.OfType <AssociationSet>().OrderBy(s => s.Name)) { builder.AppendCreateForeignKeys(associationSet); builder.AppendSql(";"); } } return(builder.GetCommandText()); }