Hi Wizman,
That would be great. I've gotten as far as creating a custom data model "Zentity.Extensions.Ontology". The model still needs some tweaking, but I have the basics working. I can add Ontological "entities" (words) using the OOB Zentity editors
and create various types of relationships among them, then visualize/PowerPivot them. It's pretty cool. Here is the basic custom model that I am using: Executing this console app creates the model and updates the database, then I have to
copy the created Zentity.Extensions.dll library to the various /bin folders in the zentity app and then.. run the Powershell script to update the Client Model.
Details on how to update the client model with the PowerShell script:
http://social.microsoft.com/Forums/en-US/zentity/thread/b9749d71-a47a-4349-a63c-881649166c50
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization;
using System.Data.Entity;
using Zentity.Core;
using System.IO;
namespace CustomDataModelModule1
{
class Program
{
const string extensionsNameSpace = "Zentity.Extensions.Ontology";
const string extensionAssemblyName = "Zentity.Extensions.Ontology";
const string connectionStringFormat = @"provider=System.Data.SqlClient;
metadata=res://Zentity.Core; provider connection string='Data Source=.;
Initial Catalog=Zentity;Integrated Security=True;MultipleActiveResultSets=True'";
static void Main(string[] args)
{
using (ZentityContext context = new ZentityContext(connectionStringFormat))
{
ResourceType resourceTypeResource = context.DataModel.Modules["Zentity.Core"].ResourceTypes["Resource"];
// Create Data Model module.
DataModelModule module = new DataModelModule { NameSpace = extensionsNameSpace };
context.DataModel.Modules.Add(module);
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Create OntologicalEntity resource type.
ResourceType resourceTypeOntologicalEntity = new ResourceType
{
Name = "OntologicalEntity",
BaseType = resourceTypeResource,
Description = "Ontological Entity",
Uri = "SomeURITest"
};
// Add Self NavigationProperties
//NavigationProperty navIsAMoreSpecificFormOf = new NavigationProperty { Name = "IsAMoreSpecificFormOf" };
//resourceTypeOntologicalEntity.NavigationProperties.Add(navIsAMoreSpecificFormOf);
//NavigationProperty navIsAMoreGenericFormOf = new NavigationProperty { Name = "IsAMoreGenericFormOf" };
//resourceTypeOntologicalEntity.NavigationProperties.Add(navIsAMoreGenericFormOf);
//Association associationSpecificGeneric = new Association
//{
// Name = "SpecificToGeneric",
// SubjectNavigationProperty = navIsAMoreSpecificFormOf,
// ObjectNavigationProperty = navIsAMoreGenericFormOf,
// SubjectMultiplicity = AssociationEndMultiplicity.Many,
// ObjectMultiplicity = AssociationEndMultiplicity.Many
//};
NavigationProperty navSynonyms = new NavigationProperty { Name = "Synonyms" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navSynonyms);
NavigationProperty navIsSynonymFor = new NavigationProperty { Name = "IsSynonymFor" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navIsSynonymFor);
Association associationSynonymous = new Association
{
Name = "Synonymous",
SubjectNavigationProperty = navSynonyms,
ObjectNavigationProperty = navIsSynonymFor,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navSubClass = new NavigationProperty { Name = "IsASubClassOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navSubClass);
NavigationProperty navSuperClass = new NavigationProperty { Name = "IsASuperClassOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navSuperClass);
Association associationSubClass = new Association
{
Name = "Taxonomy",
SubjectNavigationProperty = navSuperClass,
ObjectNavigationProperty = navSubClass,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navComprisedOf = new NavigationProperty { Name = "IsComprisedOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navComprisedOf);
NavigationProperty navIsMemberOf = new NavigationProperty { Name = "IsAMemberof" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navIsMemberOf);
Association associationGrouping = new Association
{
Name = "Grouping",
SubjectNavigationProperty = navComprisedOf,
ObjectNavigationProperty = navIsMemberOf,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navAbbreviation = new NavigationProperty { Name = "IsAbbreviationFor" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navAbbreviation);
NavigationProperty navUnabbreviated = new NavigationProperty { Name = "UnAbbreviatedForm" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navUnabbreviated);
Association associtationAbbreviation = new Association
{
Name = "Abbreviation",
SubjectNavigationProperty = navAbbreviation,
ObjectNavigationProperty = navUnabbreviated,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navMeasuredBy = new NavigationProperty { Name = "IsMeasuredIn" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navMeasuredBy);
NavigationProperty navCanMeasure = new NavigationProperty { Name = "IsMeasureOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navCanMeasure);
Association associtationUnits = new Association
{
Name = "Measure",
SubjectNavigationProperty = navMeasuredBy,
ObjectNavigationProperty = navCanMeasure,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navOwnerOf = new NavigationProperty { Name = "OwnerOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navOwnerOf);
NavigationProperty navIsOwnedBy = new NavigationProperty { Name = "IsOwnedBy" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navIsOwnedBy);
Association associtationOwner = new Association
{
Name = "Ownership",
SubjectNavigationProperty = navOwnerOf,
ObjectNavigationProperty = navIsOwnedBy,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navCollectorOf = new NavigationProperty { Name = "CollectorOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navCollectorOf);
NavigationProperty navIsCollectedBy = new NavigationProperty { Name = "IsCollectedBy" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navIsCollectedBy);
Association associtationCollection = new Association
{
Name = "Collection",
SubjectNavigationProperty = navCollectorOf,
ObjectNavigationProperty = navIsCollectedBy,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navProducerOf = new NavigationProperty { Name = "ProducerOf" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navProducerOf);
NavigationProperty navIsProducedBy = new NavigationProperty { Name = "IsProducedBy" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navIsProducedBy);
Association associtationProduction = new Association
{
Name = "Production",
SubjectNavigationProperty = navProducerOf,
ObjectNavigationProperty = navIsProducedBy,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
NavigationProperty navInhabitants = new NavigationProperty { Name = "Inhabitants" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navInhabitants);
NavigationProperty navInhabits = new NavigationProperty { Name = "Inhabits" };
resourceTypeOntologicalEntity.NavigationProperties.Add(navInhabits);
Association associtationHabitats = new Association
{
Name = "Habitats",
SubjectNavigationProperty = navInhabitants,
ObjectNavigationProperty = navInhabits,
SubjectMultiplicity = AssociationEndMultiplicity.Many,
ObjectMultiplicity = AssociationEndMultiplicity.Many
};
////Add other NavigationProperties
//NavigationProperty navSMEs = new NavigationProperty { Name = "SubjectMatterExperts" };
//resourceTypeOntologicalEntity.NavigationProperties.Add(navSMEs);
// Add Scalar Properties
// For now, the "Title" in the base "Resource" will hold the "Value" (word or phrase)
// Neighborhood might need to be a first-class entity in the model with a NavigationProperty for OntologicalEntity.
ScalarProperty Neighborhood = new ScalarProperty { Name = "Neighborhood", DataType = DataTypes.String, MaxLength = 100 };
resourceTypeOntologicalEntity.ScalarProperties.Add(Neighborhood);
ScalarProperty Level = new ScalarProperty { Name = "Level", DataType = DataTypes.Int16 };
resourceTypeOntologicalEntity.ScalarProperties.Add(Level);
ScalarProperty Source = new ScalarProperty { Name = "Source", DataType = DataTypes.String, MaxLength = 400 };
resourceTypeOntologicalEntity.ScalarProperties.Add(Source);
ScalarProperty ApprovalStatus = new ScalarProperty { Name = "ApprovalStatus", DataType = DataTypes.String, MaxLength = 400 };
resourceTypeOntologicalEntity.ScalarProperties.Add(ApprovalStatus);
ScalarProperty Version = new ScalarProperty { Name = "Version", DataType = DataTypes.String, MaxLength = 50 };
resourceTypeOntologicalEntity.ScalarProperties.Add(Version);
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
//// Create Person resource type.
//ResourceType resourceTypePerson = new ResourceType { Name = "Person", BaseType = resourceTypeResource };
//module.ResourceTypes.Add(resourceTypePerson);
//NavigationProperty navExpertInSubjects = new NavigationProperty { Name = "ExpertInSubjects" };
//resourceTypePerson.NavigationProperties.Add(navExpertInSubjects);
//// Create associationSMEs.
//Association associationSMEs = new Association
//{
// Name = "OntologicalEntityHasSMEs",
// SubjectNavigationProperty = navSMEs,
// ObjectNavigationProperty = navExpertInSubjects,
// SubjectMultiplicity = AssociationEndMultiplicity.Many,
// ObjectMultiplicity = AssociationEndMultiplicity.Many
//};
module.ResourceTypes.Add(resourceTypeOntologicalEntity);
// Synchronize the in-memory models with the backend.
context.DataModel.Synchronize();
// Generate Extensions Assembly.
//using (FileStream fout = new FileStream(@"D:\Zentity\Zentity.Extensions.Ontology.dll", FileMode.Create, FileAccess.Write))
//{
// byte[] rawAssembly = context.DataModel.GenerateExtensionsAssembly(
// extensionAssemblyName, true, null, new string[] { extensionsNameSpace }, null);
// fout.Write(rawAssembly, 0, rawAssembly.Length);
//}
using (FileStream fout = new FileStream(@"D:\Zentity\Zentity.Extensions.Ontology.dll", FileMode.Create, FileAccess.Write))
{
byte[] rawAssembly = context.DataModel.GenerateExtensionsAssembly(
extensionAssemblyName, true, null, null, null);
fout.Write(rawAssembly, 0, rawAssembly.Length);
}
// Generate Entity Framework artifacts.
EFArtifactGenerationResults results = context.DataModel.GenerateEFArtifacts(extensionsNameSpace);
results.Csdls.Where(tuple => tuple.Key == "Zentity.Core").First().Value.Save(@"D:\Zentity\ExtendedCore.csdl");
results.Csdls.Where(tuple => tuple.Key == extensionsNameSpace).First().Value.Save(@"D:\Zentity\Zentity.Extensions.Ontology.csdl");
results.Msl.Save(@"D:\Zentity\Consolidated.msl");
results.Ssdl.Save(@"D:\Zentity\Consolidated.ssdl");
}
}
}
}
Devhead
