Hi,
I am currently working on the Data Extensibility User Guide walkthrough and currently it throws an exception:
System.Data.SqlClient.SqlException was not treated.
HResult=-2146232060
Message=The stored procedure
'Core.GetDataModelModules' not found.
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
Class=16
LineNumber=1
Number=2812
Procedure=""
Server=.
State=62
StackTrace:
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj,
Boolean& dataReady)
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean
asyncWrite)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32
timeout, Task& task, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei Zentity.Core.DataModel.DataModelLoader.Refresh(DataModel model, SqlConnection storeConnection)
bei Zentity.Core.DataModel.Refresh()
bei Zentity.Core.DataModel.get_Modules()
bei ZentitySamples.Program.Main(String[] args) in c:\Users\Administrator\Documents\Visual Studio 2012\Projects\ConsoleApplication4\ConsoleApplication4\Program.cs:Zeile 25.
bei System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()
InnerException:
Code:
using Zentity.Core;
using System.Xml;
using System.Reflection;
using System;
using System.Collections;
using System.Linq;
namespace ZentitySamples
{
class Program
{
const string extensionsNamespace = "Zentity.Extensions.ScholarlyWorks";
const string connectionStringFormat = @"provider=System.Data.SqlClient;
metadata=res://{0}; provider connection string='Data Source=.;
Initial Catalog=Zentity;Integrated Security=True;MultipleActiveResultSets=True'";
const string extensionsAssemblyName = "Zentity.Extensions.ScholarlyWorks";
static void Main(string[] args)
{
using (ZentityContext context = new ZentityContext(
string.Format(connectionStringFormat, "Zentity.Core")))
{
// Create a new module.
DataModelModule module = new DataModelModule { NameSpace = extensionsNamespace };
context.DataModel.Modules.Add(module);
// Create the resource type.
ResourceType resourceTypeResource = context.DataModel.Modules["Zentity.Core"].ResourceTypes["Resource"];
ResourceType resourceTypeScholarlyWork = new ResourceType { Name = "ScholarlyWork", BaseType = resourceTypeResource };
module.ResourceTypes.Add(resourceTypeScholarlyWork);
// Create some Scalar Properties.
ScalarProperty copyright = new ScalarProperty { Name = "Copyright", DataType = DataTypes.String, MaxLength = 4000 };
resourceTypeScholarlyWork.ScalarProperties.Add(copyright);
// Synchronize to alter the database schema.
context.DataModel.Synchronize();
// Generate Extensions Assembly.
// NOTE: We have embedded the generated Entity Framework artifacts in the assembly itself.
byte[] rawAssembly = context.DataModel.GenerateExtensionsAssembly(
extensionsAssemblyName, true, new string[] { extensionsNamespace },
new string[] { extensionsNamespace }, null);
Assembly extensions = Assembly.Load(rawAssembly);
// Create some repository items using the generated assembly.
CreateRepositoryItems(extensions);
// Retrieve the created repository items.
FetchRepositoryItems(extensions);
}
}
private static void FetchRepositoryItems(Assembly extensionsAssembly)
{
using (ZentityContext context = new ZentityContext(
string.Format(connectionStringFormat, extensionsAssemblyName)))
{
Console.WriteLine("Getting ScholarlyWorks...");
Type resourceTypeScholarlyWork = extensionsAssembly.GetType(extensionsNamespace + ".ScholarlyWork");
PropertyInfo pi = resourceTypeScholarlyWork.GetProperty("Copyright");
MethodInfo ofTypeMethod = context.Resources.GetType().GetMethod("OfType").
MakeGenericMethod(resourceTypeScholarlyWork);
var customTypeInstances = ofTypeMethod.Invoke(context.Resources, null);
foreach (Resource scholarlyWork in (IEnumerable)customTypeInstances)
{
Console.WriteLine("Id:[{0}], Copyright:[{1}]", scholarlyWork.Id,
pi.GetValue(scholarlyWork, null));
}
}
}
private static void CreateRepositoryItems(Assembly extensionsAssembly)
{
using (ZentityContext context = new ZentityContext(
string.Format(connectionStringFormat, extensionsAssemblyName)))
{
Type resourceTypeScholarlyWork = extensionsAssembly.GetType(extensionsNamespace + ".ScholarlyWork");
var aScholarlyWork = Activator.CreateInstance(resourceTypeScholarlyWork);
PropertyInfo pi = resourceTypeScholarlyWork.GetProperty("Copyright");
pi.SetValue(aScholarlyWork, "A copyright value.", null);
// Save the items to repository.
context.AddToResources((Resource)aScholarlyWork);
context.SaveChanges();
}
}
}
}
