Don't think csdl/msl/ssdl are embedded

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
MarkusR
Posts: 3
Joined: Mon 18 Nov 2013 20:12

Don't think csdl/msl/ssdl are embedded

Post by MarkusR » Mon 18 Nov 2013 22:19

I am using vs2012 / devart 6.8 / .net 3.5

I am generating my model in my class library using: Add -> New Item -> Devart Entity Model...

I go through all the steps and it the model is generated. I do not see a physical csdl, msl, or ssdl file. In the edml I do see:

Code: Select all

<!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store" Alias="Self" Provider="Devart.Data.Oracle" ProviderManifestToken="Ora11g" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:devart="http://devart.com/schemas/edml/StorageSchemaExtensions/1.0" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
        <EntityContainer Name="CommPrefEntitiesStoreContainer">
          <EntitySet Name="SMS_TEMPLATEs" EntityType="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store.SMS_TEMPLATE" store:Type="Tables" Schema="MY_WEB" Table="SMS_TEMPLATE" />
          <EntitySet Name="SMS_DELIVERY_LOGs" EntityType="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store.SMS_DELIVERY_LOG" store:Type="Tables" Schema="MY_WEB" Table="SMS_DELIVERY_LOG" />
          <EntitySet Name="CUST_CELL_SETTINGS" EntityType="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store.CUST_CELL_SETTINGS" store:Type="Tables" Schema="MY_WEB" Table="CUST_CELL_SETTINGS" />
          <EntitySet Name="COMM_PREF_RESPs" EntityType="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store.COMM_PREF_RESP" store:Type="Tables" Schema="MY_WEB" Table="COMM_PREF_RESP" />
          <EntitySet Name="RETRIEVE_COMM_PREF_SETUPs" EntityType="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store.RETRIEVE_COMM_PREF_SETUP" store:Type="Views" Schema="MY_WEB" Table="RETRIEVE_COMM_PREF_SETUP" />
          <EntitySet Name="RETRIEVE_COMM_PREF_RESPs" EntityType="MyWeb.WebServices.Internal.Data.Entities.CommPref.Store.RETRIEVE_COMM_PREF_RESP" store:Type="Views" Schema="MY_WEB" Table="RETRIEVE_COMM_PREF_RESP" />
        </EntityContainer>
        <EntityType Name="SMS_TEMPLATE">
          <Key>
            <PropertyRef Name="SMS_TEMPLATE_KY" />
  
The WCF host service does not appear to be able to find the embedded resource... Here is my connection string:

Code: Select all

    <add name="CommPrefConnectionString" connectionString="metadata=res://*/CommPrefModel.csdl|res://*/CommPrefModel.ssdl|res://*/CommPrefModel.msl;provider=Devart.Data.Oracle;provider connection string="User Id=wp_web;Password=xxxx;Server=xxxx;Direct=True;Sid=av1dev;Persist Security Info=True""
      providerName="System.Data.EntityClient" />

Here is my error: Unable to load the specified metadata resource.

At first I thought it had to do with the Entity Developer but now I think it has to do with the resources not being embedded.

-Markus

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Don't think csdl/msl/ssdl are embedded

Post by Shalex » Tue 19 Nov 2013 17:12

MarkusR wrote:I think it has to do with the resources not being embedded.
Seems like this is exactly the reason of the error.
1. Visual Studio 2012 is supported by dotConnect for Oracle starting from the 7.2 version: http://www.devart.com/dotconnect/oracle ... story.html. Please upgrade. We recommend using the latest (8.1.36) build.
2. Make sure that the Metadata Artifact Processing property of your model is set to Embed In Output Assembly.

MarkusR
Posts: 3
Joined: Mon 18 Nov 2013 20:12

Re: Don't think csdl/msl/ssdl are embedded

Post by MarkusR » Tue 19 Nov 2013 21:42

Thanks you for the info!

Post Reply