ADO.NET Entity Framework and LINQ to Entities (Pre-Release) Forum

generate timestamp column using model first

Fri, 27 Nov 2009 21:29:35 Z

I have not figure out how to get EF model first to generate timestamp column on my table. I set the property to binary, column to computed, Fixed length but it still does not generate timestamp column when i right click and choose generate database from the model.

Zeeshan

Exception

Sun, 22 Nov 2009 00:08:31 Z

I'm having a new problem that has brought this entire project to a grinding halt again. I googled for info and found very little beyond the following thread. I've posted to it. If you have any suggestions, I'd be very greatful. This project is becoming quite the chore thanks to the EF instead of easier and other ORM solutions are begining to appeal. I'd really like to keep my tools 100% MS though :(

http://social.msdn.microsoft.com/forums/en-US/adodotnetentityframework/thread/eb526976-868b-4070-8220-ab86720b51ee/

Entity Key Inference

Wed, 28 Oct 2009 22:09:33 Z

Can any tell me if there is a way around the behaviour where EF will infer any non-nullable columns as entity keys in views? I can see from the VS 2010 beta that the same inference is still happening (though it still confuses me as to WHY), but I'm not able to determine whether there is a workable solution for removing the improper inference that won't get stomped by generated code every time you update the model.

These are the threads in which the problem has been discussed:

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/ea0bf748-bc97-439d-99b0-76180b2161bb/

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/86f231fb-c42f-4297-83f6-5ffd4e972e47

Thanks for any insight that can be provided.

Use of model defined functions on properties / methods of an entity

Fri, 27 Nov 2009 15:59:07 Z

After looling a little to mdf, this is something I need. The standard way seems to be this something like this :

 <Function Name="IsAdult" ReturnType="Edm.Boolean">
  <Parameter Name="student" Type="AlertesModel.Student" />
  <DefiningExpression>
   student.BirthDate &lt;= AddYears (CurrentDateTime(), -18)
  </DefiningExpression>
 </Function>
   
   public static class EFFunctions
   {
      [System.Data.Objects.DataClasses.EdmFunction ("Model", "IsAdult")]
      public static bool IsAdult (Student Student)
      {
         throw new NotSupportedException ("Direct calls are not supported.");
      }
   }



   public static int GetStudentsAdultCount ()
   {
      using (ModelContainer context = new ModelContainer ())
      {
         var query =
            from e in context.Students
            where EFFunctions.IsAdult (e)
            select e;
         return query.Count ();
      }
   }

With extensions methods, we can do a little better when building Linq To Entity queries :

   public static class EFFunctions
   {
      [System.Data.Objects.DataClasses.EdmFunction ("Model", "IsAdult")]
      public static bool IsAdult (this Student Student)
      {
         throw new NotSupportedException ("Direct calls are not supported.");
      }
   }

   public static int GetStudentsAdultCount ()
   {
      using (ModelContainer context = new ModelContainer ())
      {
         var query =
            from e in context.Students
            where e.IsAdult ()
            select e;
         return query.Count ();
      }
   }

But this could be nicer if we could define the function inside the entity class instead of "MyCustomsFunctions" class like this :

	<Function Name="IsAdult" ReturnType="Edm.Boolean">
		<DefiningExpression>
			it.BirthDate &lt;= AddYears (CurrentDateTime(), -18)
		</DefiningExpression>
	</Function>

   public class Student
   {
      [System.Data.Objects.DataClasses.EdmFunction ("Model", "IsAdult")]
      public bool IsAdult
      {
         get { throw new NotSupportedException ("Direct calls are not supported."); }
      }

      // Or

      [System.Data.Objects.DataClasses.EdmFunction ("Model", "IsAdult")]
      public bool IsAdult ()
      {
         throw new NotSupportedException ("Direct calls are not supported.");
      }
   }

   public static int GetStudentsAdultCount ()
   {
      using (ModelContainer context = new ModelContainer ())
      {
         var query =
            from e in context.Students
            where e.IsAdult // Or e.IsAdult ()
            select e;
         return query.Count ();
      }
   }

So with extension methods, it's nice, but is there any way to do something better ?
- Keep the Linq Query syntaxe using "e.XXXX" instead of "EFFunctions.XXXX"
- Declare the EdmFunction inside the entity class (we can't do extension methods on non-static classes).

Allow custom attrubutes for entity objects to be created using designer

Fri, 27 Nov 2009 15:40:27 Z

Please allow custom attributes (similar to .Net custom attributes) for entity types, properties, navigation properties, associations etc to be created using entity designer.
Ideally I would have the ability to create dictionary of custom attributes for model (may be restricting attributes to concrete targets: types, properties etc) and to apply these attributes to concrete objects.
Then I wish to use these attributes in custom tt-file to customize code generation.
Sometimes it would be useful to define some properties of the attributes (for example Value) to have additional flexibility in code generation.

EDM4 with POCO x WebService

Tue, 17 Nov 2009 14:17:13 Z

I have a problem with this code:

My class:
public class People()
{
    private List<People> _peopleparent = new List<People>();

    public virtual int Id { get; set; };
    public virtual string Name { get; set; }
    public virtual int? ParentId { get; set; }
    public virtual People Parent { get; set; }
    public virtual List<People> PeopleParent
    {
        get { return _peopleparent; }
        set { _peopleparent = value; }
    }
}

My webservice:
public class PeopleWS : System.Web.Services.WebService
{
    ModelContext db = new ModelContext();

    [WebMethod]
    public List<People> SelectAll()
    {
        return (from q in db.People select q).ToList();
    }
}

The error when I execute the webservice:
System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: A circular reference was detected while serializing an object of type PeopleWS.People.

CodeOnly ManyToMany

Tue, 17 Nov 2009 18:06:39 Z

Lets say that I have simple model with a ManyToMany relation between Foos and Bars.
If the model has Foo.Bars and Bar.Foos it´s simple to config a relation and a BarFoo table.

Relationship(f => f.Bars).FromProperty(b => b.Foos);

But what if I would like the DB to have ManyToMany but it ain´t reflected in the model.
So Foo no longer has the Foo.Bars collection.

If I configure this using Map to set up a relation table with Foo.Id and Bar.Id I get a table with one of the Id´s as Primary key.

Relationship(b => b.Foos).Map(new StoreTableName("BarFoo", "dbo"), (b, f) => new { barId = b.Id, fooId = f.Id });

How do I set up this scenario with CodeOnly to get both Id as combined Key ?

Once again about large model splitting

Thu, 26 Nov 2009 09:13:45 Z

I've read about current approach to large model splitting (here).

When using model(s) from another model (and having inheritance, association and navigation properties between different models) will be available through designer? Also it would be great to have abilty to choose subset of objects from "used" model which will be placed on another model designer surface.

When multiple designer windows are planned to be implemented (this question was asked here)?

Thank you.

Getting SqlException "Invalid column name 'User_Id' from EF4 code-only

Tue, 24 Nov 2009 13:27:04 Z

I got a strange behaviour with code only (EF CTP) where I get an EntityCommandExecutionException, and the inner exception is a SQLException saying: Invalid column name 'User_Id'.

The strange thing with this is that my POCO does not contain a User_Id (there is even no such field/property in my whole solution).

Here is the stack trace from the EntityCommandExecutionException:

   at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Repositories.EF.EFRepository`2.GetAll() in C:\Projects\Repositories.EF\EFRepository.vb:line 64
   at epositories.Website.EFBlogAggregateRepository.GetAllBlogs() in C:\Projects\Repositories.Website\EntityFramework\Repositories\AggregateRepositories\EFBlogAggregateRepository.vb:line 18
   at Repositories.Test.BlogTest.GetAllBlogs() in C:\Projects\Repositories.Test\BlogTest.vb:line 70

Does anybody have an idea what is going on here?

Am I missing Code Generation Items for Beta 2 and the Feature CTP?

Tue, 24 Nov 2009 14:07:29 Z

After seeing EF4 shown off at PDC last week, I want to experiment w/ EF4's POCO support. I installed the Feature CTP, I created a new C# Class Library, added an EDM, and set the code generation strategy to "None". When I right click inside the model though and click Add Code Generation Item, I'm only presented w/ two options, "ADO.NET EntityObject Generator" and "ADO.NET Self-Tracking Entity Generator".

During the session I attended at PDC, I remember seeing a few more than this and along with those, there was an item for generating POCO's. Is there something in additional to Beta 2 and the Feature CTP that I need to install to get this Code Generation Item?

Blades Don't Need Reloading...

ExecuteFunction throws exception EF4 CTP2

Tue, 24 Nov 2009 15:47:41 Z

I was able to replicate this on two computers
I have a simple stored procedure

CREATE

PROCEDURE checkstate @param varchar(11)
AS
RETURN 1
GO

In my EDMX I imported it as Function checkstate

Return Scalar Int32 (when I click Get Column Info. it says correctly "The selected stored procedure returns no columns")
but when I call

static void Main(string[] args)

{

   using (var model = new SystemEntities())
   {
      model.checkstate("anything");
   }
}

it throws exception
The data reader returned by the store data provider does not have enough columns for the query requested.

I can replacate this on two different machines (different dbs too) Can anyone help?

Thank you

Add expression based version to include operator

Tue, 24 Nov 2009 10:24:06 Z

Currently new EF 4.0 has context.LoadProperty method which uses expression syntax to get property name.

I think you should add the same overload to ObjectQuery Include method.

Example:
products.Include(p => p.Tags)

SQL code for Any extension method optimization

Wed, 25 Nov 2009 15:53:48 Z

Seems that t-sql query simplification and optimization may be implemented for method Any.
Now for code
bool v = p.Objects.Any(o => o.Id < 0);
this T-SQL code is generated
SELECT
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[Objects] AS [Extent1]
WHERE [Extent1].[ID] < 0
)) THEN cast(1 as bit) WHEN ( NOT EXISTS (SELECT
1 AS [C1]
FROM [dbo].[Objects] AS [Extent2]
WHERE [Extent2].[ID] < 0
)) THEN cast(0 as bit) END AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable1]

Second when (with NOT EXISTS) is not required. It may be replaced with else:
SELECT
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[Objects] AS [Extent1]
WHERE [Extent1].[ID] < 0
)) THEN cast(1 as bit)
ELSE cast(0 as bit) END AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable1]

Also I believe that this variant is more reliable. Imagine that there were not rows with Id<0 when first WHEN was checked (check result is false). After it second WHEN is being checked. But before this check (and after first check) one or several rows with Id < 0 were added (if you not use SERIALIZABLE isolation level). Then second WHEN will be false and implicit ELSE will be executed. This else will return NULL. I suppose (not sure) that will be exception.

The EntityReference object could not be serialized

Wed, 25 Nov 2009 07:40:36 Z

I have an n-tier solution using Silverlight/WCF/Entity Framework that I recently upgraded from .NET 3.5 to .NET 4.0 (beta 2). In one of my test methods (in a separate project which calls the WCF service), I have the following code:

private SharedFile CreateSharedFile(Room room, User user)
{
    string originalFileLocation = @"c:\SharedFiles\" + Guid.NewGuid() + @"\somefilename.txt";
    SharedFile sharedFile = new SharedFile()
    {
        SharedFileId = Guid.NewGuid(),
        OriginalFileLocation = originalFileLocation,
        OriginalFileUploadedOn = DateTime.Now,
        OriginalFileName = "somefilename.txt"
    };
    sharedFile.ConvertedFileUri = "http://localhost/somefilename.txt";
    sharedFile.ConvertedFileTypeId = "Text";
    sharedFile.User = user;
    sharedFile = roomService.CreateSharedFile(sharedFile);
    return sharedFile;
}

Under EF V1/NET 3.5, this worked fine. However, now it's throwing this error (on the roomService.CreateSharedFile(sharedFile) line):

System.InvalidOperationException: The EntityReference object could not be serialized. This type of object cannot be serialized when the RelationshipManager belongs to an entity object that does not implement IEntityWithRelationships.

It's certainly not the most unintelligible error message that I've received, but it's maybe in the top 20. And Google searches -- err, sorry, Bing searches -- aren't returning anything related to that error. I'm specifically confused about the reference to RelationshipManager/IEntityWithRelationships, because the "SharedFile" class in question is generated by the Add Service Reference dialog box, so I'm not sure how/when/where it could need to deal with EF relationships.

Any thoughts about what's going wrong?

Ken Smith

Bug when using stored proc to update multiples children entities

Wed, 21 Oct 2009 13:40:35 Z

When I change multiples children entities instances and their update is mapped to a stored proc, I get an Update Exception : Unable to determine a valid ordering for dependent operations. Dependencies may exist due to foreign key constraints, model requirements, or store-generated values.

But if I update only 1 child or remove the stored proc mapping, all goes well.

Here is the code to reproduce the bug:

using System;
using System.Data;
using System.Linq;

namespace ConsoleApplication1
{
   class Program
   {
      static void Main (string[] args)
      {
         using (TestEntities context = new TestEntities ())
         {
            var toUpdate = (from t in context.Composant.Include ("Descriptions")
                            select t).First ();

            int nbrUpdates = 0;
            foreach (var description in toUpdate.Descriptions)
            {
               description.Description = "new description " + Guid.NewGuid ().ToString ();
               nbrUpdates++;
            }

            if (nbrUpdates < 2)
               throw new InvalidOperationException ("Cannot reproduce bug with only 1 update.");

            try
            {
               context.SaveChanges ();
            }
            catch (UpdateException exc)
            {
               throw new InvalidOperationException ("Bug reproduced.", exc);
            }

         }
      }

   }
}

And this is the edmx file :

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
	<edmx:Runtime>
		<!-- SSDL content -->
		<edmx:StorageModels>
		<Schema Namespace="TestStoreNamespace" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
        <EntityContainer Name="TestStoreNamespaceContainer">
          <EntitySet Name="Composant" EntityType="TestStoreNamespace.Composant" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="ComposantDescr" EntityType="TestStoreNamespace.ComposantDescr" store:Type="Tables" Schema="dbo" />
          <AssociationSet Name="FK_dbo_ComposantDescr_dbo_Composant" Association="TestStoreNamespace.FK_dbo_ComposantDescr_dbo_Composant">
            <End Role="Composant" EntitySet="Composant" />
            <End Role="ComposantDescr" EntitySet="ComposantDescr" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Composant">
          <Key>
            <PropertyRef Name="IdComposant" />
          </Key>
          <Property Name="IdComposant" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="ComposantDescr">
          <Key>
            <PropertyRef Name="IdComposant" />
            <PropertyRef Name="TypeDescription" />
          </Key>
          <Property Name="IdComposant" Type="int" Nullable="false" />
          <Property Name="TypeDescription" Type="int" Nullable="false" />
          <Property Name="Description" Type="nvarchar(max)" />
        </EntityType>
        <Association Name="FK_dbo_ComposantDescr_dbo_Composant">
          <End Role="Composant" Type="TestStoreNamespace.Composant" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="ComposantDescr" Type="TestStoreNamespace.ComposantDescr" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Composant">
              <PropertyRef Name="IdComposant" />
            </Principal>
            <Dependent Role="ComposantDescr">
              <PropertyRef Name="IdComposant" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="sp_ComposantDescr_U" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="pId" Type="int" Mode="In" />
          <Parameter Name="pTypeDescription" Type="int" Mode="In" />
          <Parameter Name="pDescription" Type="nvarchar(max)" Mode="In" />
        </Function>
      </Schema></edmx:StorageModels>
		<!-- CSDL content -->
		<edmx:ConceptualModels>
			<Schema Namespace="TestNamespace" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
				<EntityContainer Name="TestEntities">
					<EntitySet Name="Composant" EntityType="TestNamespace.Composant" />
					<EntitySet Name="ComposantDescr" EntityType="TestNamespace.ComposantDescr" />
          <AssociationSet Name="FK_dbo_ComposantDescr_dbo_Composant" Association="TestNamespace.FK_dbo_ComposantDescr_dbo_Composant">
            <End Role="Composant" EntitySet="Composant" />
            <End Role="ComposantDescr" EntitySet="ComposantDescr" /></AssociationSet>
				</EntityContainer>
				<EntityType Name="Composant">
					<Key>
						<PropertyRef Name="IdComposant" />
					</Key>
					<Property Type="Int32" Name="IdComposant" Nullable="false" />
          <NavigationProperty Name="Descriptions" Relationship="TestNamespace.FK_dbo_ComposantDescr_dbo_Composant" FromRole="Composant" ToRole="ComposantDescr" />
				</EntityType>
				<EntityType Name="ComposantDescr">
					<Key>
						<PropertyRef Name="IdComposant" />
						<PropertyRef Name="TypeDescription" />
					</Key>
					<Property Type="Int32" Name="IdComposant" Nullable="false" />
					<Property Type="Int32" Name="TypeDescription" Nullable="false" />
					<Property Type="String" Name="Description" MaxLength="Max" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Composant" Relationship="TestNamespace.FK_dbo_ComposantDescr_dbo_Composant" FromRole="ComposantDescr" ToRole="Composant" />
				</EntityType>
        <Association Name="FK_dbo_ComposantDescr_dbo_Composant">
          <End Type="TestNamespace.Composant" Role="Composant" Multiplicity="1" >
            <OnDelete Action="Cascade" /></End>
          <End Type="TestNamespace.ComposantDescr" Role="ComposantDescr" Multiplicity="*" >
            </End>
          <ReferentialConstraint>
            <Principal Role="Composant">
              <PropertyRef Name="IdComposant" /></Principal>
            <Dependent Role="ComposantDescr">
              <PropertyRef Name="IdComposant" /></Dependent></ReferentialConstraint></Association>
			</Schema>
		</edmx:ConceptualModels>
		<!-- C-S mapping content -->
		<edmx:Mappings>
		<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
  <EntityContainerMapping StorageEntityContainer="TestStoreNamespaceContainer" CdmEntityContainer="TestEntities">
    <EntitySetMapping Name="Composant">
      <EntityTypeMapping TypeName="IsTypeOf(TestNamespace.Composant)">
        <MappingFragment StoreEntitySet="Composant">
          <ScalarProperty Name="IdComposant" ColumnName="IdComposant" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="ComposantDescr">
      <EntityTypeMapping TypeName="IsTypeOf(TestNamespace.ComposantDescr)">
        <MappingFragment StoreEntitySet="ComposantDescr">
          <ScalarProperty Name="IdComposant" ColumnName="IdComposant" />
          <ScalarProperty Name="TypeDescription" ColumnName="TypeDescription" />
          <ScalarProperty Name="Description" ColumnName="Description" />
        </MappingFragment>
      </EntityTypeMapping>
            <EntityTypeMapping TypeName="TestNamespace.ComposantDescr">
              <ModificationFunctionMapping>
                <UpdateFunction FunctionName="TestStoreNamespace.sp_ComposantDescr_U" >
                  <ScalarProperty Name="Description" ParameterName="pDescription" Version="Current" />
                  <ScalarProperty Name="TypeDescription" ParameterName="pTypeDescription" Version="Original" />
                  <ScalarProperty Name="IdComposant" ParameterName="pId" Version="Original" /></UpdateFunction></ModificationFunctionMapping></EntityTypeMapping>
    </EntitySetMapping>
  </EntityContainerMapping>
</Mapping></edmx:Mappings>
	</edmx:Runtime>
	<Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
		<Connection>
			<DesignerInfoPropertySet>
				<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
			</DesignerInfoPropertySet>
		</Connection>
		<Options>
			<DesignerInfoPropertySet>
				<DesignerProperty Name="ValidateOnBuild" Value="False" />
				<DesignerProperty Name="EnablePluralization" Value="False" />
				<DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
			</DesignerInfoPropertySet>
		</Options>
		<Diagrams>
			<Diagram Name="TestEntities" ZoomLevel="95">
				<EntityTypeShape EntityType="TestNamespace.Composant" Width="2.125" PointX="3.25" PointY="1.625" Height="1.4033821614583339" />
				<EntityTypeShape EntityType="TestNamespace.ComposantDescr" Width="1.75" PointX="7.375" PointY="1.375" Height="1.787985026041667" />
        <AssociationConnector Association="TestNamespace.FK_dbo_ComposantDescr_dbo_Composant" >
          <ConnectorPoint PointX="5.375" PointY="2.3266910807291667" />
          <ConnectorPoint PointX="7.375" PointY="2.3266910807291667" /></AssociationConnector>
			</Diagram>
		</Diagrams>
	</Designer>
</edmx:Edmx>

and the T-Sql code for SqlExpress to create the database with datas :

CREATE TABLE [dbo].[Composant] (
    [IdComposant] int  NOT NULL
)
GO

CREATE TABLE [dbo].[ComposantDescr] (
    [IdComposant] int  NOT NULL,
    [TypeDescription] int  NOT NULL,
    [Description] nvarchar(max)  NULL
)
GO

ALTER TABLE [dbo].[Composant] WITH NOCHECK 
ADD CONSTRAINT [PK_Composant]
    PRIMARY KEY CLUSTERED ([IdComposant] ASC)
GO

ALTER TABLE [dbo].[ComposantDescr] WITH NOCHECK 
ADD CONSTRAINT [PK_ComposantDescr]
    PRIMARY KEY CLUSTERED ([IdComposant], [TypeDescription] ASC)
GO

ALTER TABLE [dbo].[ComposantDescr] WITH NOCHECK 
ADD CONSTRAint [FK_dbo_ComposantDescr_dbo_Composant]
    FOREIGN KEY ([IdComposant])
    REFERENCES [dbo].[Composant] ([IdComposant])
    ON DELETE CASCADE ON UPDATE CASCADE
GO
 
Create PROCEDURE [dbo].[sp_ComposantDescr_U]
   @pId int, @pTypeDescription int, @pDescription nvarchar(max)
AS
BEGIN
  
  SET NOCOUNT ON;

  -- Sample stored proc, the real one has more complexities
 
  Update Upd
	Set Description = @pDescription
  From
    dbo.ComposantDescr Upd
    Where Upd.IdComposant = @pId
      And Upd.TypeDescription = @pTypeDescription
END
GO

INSERT INTO [Test].[dbo].[Composant]
           ([IdComposant])
     VALUES
           (1)
GO

INSERT INTO [Test].[dbo].[ComposantDescr]
           ([IdComposant]
           ,[TypeDescription]
           ,[Description])
     VALUES
           (1
           ,0
           ,'0 description')
GO

INSERT INTO [Test].[dbo].[ComposantDescr]
           ([IdComposant]
           ,[TypeDescription]
           ,[Description])
     VALUES
           (1
           ,2
           ,'2 description')
GO

So how can I solve this problem? We are using lot of stored proc to update / insert / delete int our descriptions tables, and this is a big problem for us.

EF POCO in n-Tier

Wed, 25 Nov 2009 10:32:35 Z

Hi,

We are trying to use EF POCO entities in WCF:

1. first problem we faced is that entities cannot be send if cotnext proxy generation option is not disabled.
2. ApplyCurrentValues doesn't persist ref properties (ICollection<Tag>, Product etc). It only saves changes of value properies.

Explicit transactions (with custom settings)

Wed, 25 Nov 2009 09:38:01 Z

Hi *,

sometimes you may need to set up transaction in your database in a very precise way, using all power of favorite engine. Sadly it's not possible now. If you write something like (I know, this case I can make work via i.e. TransactionScope easily):

ent.Connection.Open();
IDbTransaction tx = ((ent.Connection as EntityConnection).StoreConnection as SqlConnection).BeginTransaction(IsolationLevel.Serializable);
ent.MASTER.ToArray();
tx.Commit();

You end up with nice exception ;), because there was a transaction, but wasn't assigned to command used for the query. Are there any plans to address this issue? Maybe we can discuss here some ideas as the transactions are core part of RDBMSs.

Jiri {x2} Cincura

MVC and Self Tracking Entities

Tue, 24 Nov 2009 02:47:14 Z

When I'm using self tracking entities which are displayed in a form on an MVC view, the form values are posted to the Controller once updated.

I would then need to re-create these entities from the posted form values. Wouldnt this lose tracking information needed for Optimistic locking?

How can I work with self tracking entities in scenarios like this without storing the objects somewhere e.g. in the Session ?

Self-Tracking Entities with Stored Procedure in Entity Framework

Tue, 24 Nov 2009 07:35:26 Z

Dears,

Technologies
===============
Technologies that I must use is WCF and Stored Procedures and Entity Framework to read data out, not for insert, update and delete

Tasks
===============
Create a combo box with Category, when users change the selection on the combo box, a list of relative subcategories will be shown on a grid.
User is able to create a new category directly and input some new subcategories as well.

Databases
===============
Category
{
    CategoryID        INT
    CategoryName   VARCHAR(50)
}

SubCategory
{
    SubCategoryID        INT
    SubCategoryCode    VARCHAR(20)
    SubCategoryName   VARCAAR(50)
}

Category   1 <---> N   SubCategory

Stored Procedures
===============
GetAllCategories() returns [Category] Entity

Since I want to make those entities seperated from the DB but with Self Tracking functionalities for N-Tier application.
I want to do something like shown as the following

Implementation Class
================
using (InventoryEntities context = new InventoryEntities)
{
      Category[]  categoryList = context.GetAllCategories().ToArray();
}

As this time, I can't use include since the return type for GetAllCategory() is a ObjectResult<Category> rather than ObjectSet<Category>
I want to retrieve category with its subcategories at the same queries and the main point is using stored procedure.

This is a very simple scenario but I must deal with this situation successfully before I move further away.

If I want to return a self-tracking entities (For update purpose through WCF and N-Tiers architecture) with the following information
with the specified technologies required, what can I do?

Category ID      Category Name    SubCategory ID     SubCategory Name
     1                    Hardware
                                                            1                       Server
                                                             2                     Notebook
                                                             3                       Monitor
    2                      Software
                                                             4                       License
    3                       Others
                                                             5                      Service

Could anyone gives me a suggestion how can I achieve my purpose?

10 millions Thanks !!!!

Model First: How Do I Designate A Property (Column) To Have A UNIQUE INDEX?

Thu, 19 Nov 2009 05:19:40 Z

Hi,

I'm using EF 4 Beta 2 and Sql Server 2008. I'm doing model first design, and I'm wondering if/how I can designate a field to have a UNIQUE INDEX in the database? Can this be done? If not, is there a workaround? I can't I put indexes directly in Sql Server, cause every time I re-generate the database I'd lose them all.

Thanks!

Spinal

Using Entity Framework 4 with SQL Server 2000 Databases

Tue, 24 Nov 2009 21:05:57 Z

The Visual Studio 2010 IDE does not support connecting to SQL Server 2000, including not allowing connections from the ADO.NET Entity Framework designer. However, the ADO.NET Entity Framework 4 runtime continues to offer support for running with SQL Server 2000 databases. A number of people have asked what to do with existing ADO.NET Entity Framework models built against SQL Server 2000 when moving to Visual Studio 2010. Following are a few development options and items of note:

- The ADO .NET Entity Framework 4 runtime fully supports SQL Server 2000.

- Apps you previously built on top of SQL Server 2000 will continue to function as-is when you move those apps to the ADO.NET Entity Framework 4 runtime.

- EdmGen.exe is a command line utility that can be used to create ADO.NET Entity Framework models. It is still possible to use EdmGen.exe to generate ADO.NET Entity framework models for SQL Server 2000 databases.

- To use the Visual Studio 2010 tools with models built on top of SQL Server 2000 it’s possible to mirror your SQL Server 2000 schemas to SQL Server 2008 and SQL Server 2008 R2 instances for use with the designer tools.

Thanks, Tim Laverty

PM, Entity Framework

Set referntial integrity like cascade delete integrated into visual studio model designer?

Sat, 21 Nov 2009 11:31:17 Z

Hello,

with EF v1.0 I did this:

that way all products got deleted when I deleted a category. How must I do this in VS 2010 beta 2? Also change in manually in xml code?? terrible...

< Association Name = " CProductCategory " >

< End Type = " Self.CProduct " Multiplicity = " * " />

< End Type = " Self.CCategory " Multiplicity = " 0..1 " >

< OnDelete Action = " Cascade " />

</ End >

</ Association >

Self-Tracking Entities: Why is 'ChangeTrackingEnabled' = false By Default?

Thu, 19 Nov 2009 19:35:32 Z

When using Self-tracking entities, I don't like having to call StartTracking() on all objects to have them start their tracking. I realize that after de-serializing calls this automatically, but I don't want to assume that these objects will only need to start tracking then, I might want to track entities on the server side as well.

Can I safely adjust the field on the ChangeTrackingEnabled field on the ObjectChangeTracker object to default to 'true'? After looking at the generated code, I don't think it will adversely affect anything, but not sure if I'm missing anything.

Any help is appreciated.

Thanks,
Spiny

POCO with EDMX : How map POCO entities from different namespaces in single EDMX

Tue, 24 Nov 2009 07:35:00 Z

How can I map POCO entities from different namespaces in single EDMX?

In my application I want to have one context, that work with all POCO entities which are located in different assemblies.

How to map a simple association and a composition in entity framework

Fri, 13 Nov 2009 16:11:45 Z

We have the following scenarios:

Associate a Invoice to a Customer POCO.

If the associated customer does not exist an insert of the Invoice should fail. It should not attempt to insert the customer.

Associate a Invoice to InvoiceLines POCOs.

All InvoiceLines in the collection should be inserted.

Talking in terms of UML notation what is the diference in CSDL and MSL of Aggregation and Composition?

Thank you,

Pedro

Pedro Salgueiro

SQL timestamp in VB POCO object

Tue, 24 Nov 2009 02:49:31 Z

I'm using POCOs with the latest version of EF 4.0 and have a timestamp field on my SQL Server 2008 db for handling optimistic concurrency.

The designer has created a mapping for the field with as an entity type of Binary. How should this be represented in my VB POCO as EDM.Binary is not available there? When I have the field as a Byte array, I get the error:

The type 'Edm.Binary' of the member 'RowVersionNr' in the conceptual side type 'SchoolModel.Course' does not match with the type 'System.Byte' of the member 'RowVersionNr' on the object side type 'EFLibrary.Course'.

Custom Code Generation Strategy?

Mon, 23 Nov 2009 18:41:36 Z

Hi,
I created a custom Database Generation Workflow for database code generation and it works great.

(For anyone interested, I followed the lead of the 'dev guy's 'D3' app:
(http://blogs.msdn.com/dsimmons/archive/2009/06/30/d3-building-great-software-is-a-battle-don-t-leave-any-assets-on-the-sidelines.aspx)

I would like to do the same thing for the Code generation - is there such a thing? I know i can create T4 scripts and attach them to the edmx file, but I'd like to go one further and have actual C# code triggered, primarily to do more in-depth integration with VS, such as automatic check-outs, etc. I see this can be done on the db gen side with workflow activities, but does the code generation side of things have the same capability? Or am I best off just sticking to the existing database generation workflow for this kind of thing?

Thanks!

Spinal

Creating/Updating entities with complex relationships

Thu, 29 Oct 2009 23:36:56 Z

Hi,

Having migrated our projects to VS 2010 Beta2, we are trying the EF 4.0 as orm for the DAL, and have the following scenario:
Based on our own DSL, we are generating, besides other components, the following elements relevants for the question:
1. Database scripts.
2. Business Entities (POCOs). For this purpose, let's assume as simple classes with getters and setters.
3. EF files (ssdl, csdl, and msl).
4. Classes that inherit from from ObjectContext, storing ObjectSet's for each entities.

We can successfully create and update simple entites with the following code (example for a Product object):

		public void CreateProduct (Product instance)
		{
			products.Attach(instance);
            ObjectStateManager.ChangeObjectState(instance, EntityState.Added);
			products.AddObject(instance);
			this.SaveChanges();
		}
		
		public void UpdateProduct (Product instance)
		{
			products.Attach(instance);
            ObjectStateManager.ChangeObjectState(instance, EntityState.Modified);
			products.ApplyCurrentValues(instance);
			this.SaveChanges();
		}

In this case, products is of type ObjectSet<Product>.

The problems start when the objects are more complex. For example, in a master-detail scenario (ex: Order-OrderDetails), we are getting the following error:

"An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key".
It occurs in the line of the Attach method, as the example above (in that case invoices.Attach(instance); )

As we are new with EF, we are not really sure about if this is the better way to implement these Create/Update methods. Also, and as I could understand, it seems to be something related with self-tracking entities, and have read about the Entity Framework Feature which is still not shipped for VS 2010 Beta2.

So, the question is, is this the right way to do the job and what is missing for these scenarios? Does the EF Feature CTP effectively the best way to handle this?

Many thanks in advance.

paulo

stored procedure- multiple return types

Wed, 18 Nov 2009 11:49:00 Z

Hi,

I am trying to migrate my code to EF4 and I need help using stored proc that returns multiple result types.
In linq to sql i managed doing it by using "IMultipleResults " interface and "ResultType" attribute.
How can I use sp with multiple results type in EF4?

[Function(Name = "dbo.P_USR_UserSummeryDetails")]
        [ResultType(typeof(User))]
        [ResultType(typeof(Operation))]
        [ResultType(typeof(OrganizationUnit))]
        [ResultType(typeof(OrganizationUnit))]        
        [ResultType(typeof(Role))]
        [ResultType(typeof(User))]
        [ResultType(typeof(User))]
        public IMultipleResults GetUserSummeryDetails(int userID, string loginName, int fillMode)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), userID, loginName, fillMode);
            return ((IMultipleResults)(result.ReturnValue));
        }

DetectChanges not required when you you call objectset.addobject

Sat, 21 Nov 2009 19:14:11 Z

I am using plain POCO with no proxies.

var db = new CustomContext();

var speaker = new Speaker { Name = "John" };

var talk1 = new Talk { Title = "New EF4 features" };

speaker.Talks = new List<Talk>() { talk1 };

//object graph not synced

Console.WriteLine("talk1.Sepaker is null {0}",talk1.Speakers == null);

db.Speakers.AddObject(speaker);

//object graph synced

Console.WriteLine("talk1.Sepaker is not null {0}", talk1.Speakers.Count() > 0);

As soon as i add the speak to the objectset of speakers both sides of the graph is synced and changes on the object are noticed by the statemanager. I thought DetectChanges is an expensive operation which is only called when you call SaveChanges or when you explicitly call detect changes. atleast that's what the blog says.

Because DetectChanges is potentially expensive, it isn’t called explicitly during the other APIs on ObjectContext that rely on the state manager being in sync with the object graph. As a result, you have to call DetectChanges whenever you are performing state dependent operations on the context.

Zeeshan Hirani

How to declare many to many relationship in code only scenario

Sat, 21 Nov 2009 06:14:09 Z

How to declare many to many relationship in code only scenario?

How to get a bindable collection from EF4?

Sun, 22 Nov 2009 20:56:21 Z

I'm experimenting with databinding using WPF and EF4.

I generated my model first, which includes a Product entity.

I'd like to have a databound-property that holds a collection of product entities, and supports change notification (when an item is added/deleted)

Currently I'm converting the resulting ObjectSet<Product> into an ObservableCollection, but there must be an easier way. Now, I have to synchronize two collections.

Any help on this is appreciated!

ObjectStateEntry Not Showing Correct State During SavingChanges Event

Thu, 19 Nov 2009 19:15:56 Z

Hi,
I'm using Self-tracking entities in EF4. I have a 'LastModified' DateTime field in all my entities that I want to update on all inserts/updates,
so I've implemented an event handler for my ObjectContext's 'SavingChanges' event. In it, I inspect all the ObjectStateEntries on the context's ObjectStateManager, as follows:

private void context_SavingChanges(object sender, EventArgs e)
{
    ObjectContext context = sender as ObjectContext;
    if (context != null) {
foreach (ObjectStateEntry entry in context.ObjectStateManager.GetObjectStateEntries(EntityState.Added | EntityState.Modified))   {
   . . .

}
}

It works fine for new objects that I spin up and insert, but when updating a loaded entity, the ObjectStateEntry.State is never 'Modified', it's always 'Unchanged', even though the entity that it's referencing is 'Modified' (the entity's StateTracker, that is). This is not the case for inserts, only updates. I could start checking State of the entities themselves, instead of the ObjectStateEntry, but I have the feeling I'm doing something wrong to cause this issue. My calling code is simply:

using (var context = new MyContext()) {

var results = from f in context.Foo
where f.Id == 123
select f;
Foo foo = results.SingleOrDefault<Foo>();

foo.StartTracking();
foo.Name = "some string";

context.Foo.ApplyChanges(foo);
context.SaveChanges();
}

Any ideas are much appreciated!

Thanks,
Spinal

Is detectchanges called before savingchanges or after?

Sat, 21 Nov 2009 20:03:36 Z

If i have business logic applied in saving changes event on pure poco object, those get unnoticed. Apparently Ef calls detect changes after SavingChanges so some of my business logic gets skipped for instance in the code below, I dont get anything for added talks state entries cuz snapt shot happens after saving changes. What are the recommendations and also what happens if i override SaveChanges method, do I take the responsibility of invoking detectchanges then?

I think diego mentioned in ado.net blog comment that DetectChanges is called before SavingChanges event fire which i don't understand. diego can u pls explain?

"Regarding your second point, in SaveChanges, by default, DetectChanges is invoked right before raising the SavingChanges event, so you shouldn't need to call DetectChanges yourself."

speaker.Talks.Add(new Talk { Title = "jquery intro" });

db.SaveChanges();

void CustomContext_SavingChanges(object sender, EventArgs e)

{

var addedtalks = this.ObjectStateManager.GetObjectStateEntries(EntityState.Added)

.Where(en => en.Entity is Talk)

.Select(en => en.Entity as Talk);

foreach (var talk in addedtalks)

{

talk.CreateDate = DateTime.Now;

}

Zeeshan Hirani

ADO.Net EF V4 Beta 2 - Limitation or Mistake? - PROC Mapping for Insert/Update/Delete - More than 1 return parameter

Fri, 20 Nov 2009 11:45:33 Z

I'm concerned I've hit a limitation in the ADO.Net EF 4 (beta 2), but I'm not sure if that's the case, or I'm just doing something wrong. I have an entity that includes an identity field and a computed column. The insert PROC needs to return 2 values to update the entity and one of those values is used is an Association. The update PROC needs to return 1 value and it's also the one used in a mapping. In both cases, that value also needs to be an input to the PROC (for business logic handles in sql that can be seen in the proc below). Can someone tell me what I'm doing wrong with my ModificationFunctionMapping, or if I've hit a limitation in the EF. In the designer, I get the impression I can't have 2 ResultBindings, and even then, it seems I can't use them because the field is used in a NavigationProperty.

Thanks in advance for any/all help. This is a show-stopper for this project since I must rely on views/procs for security reasons (until/unless transparent row-level security is available to me in this scenario with SQL 2008 and the EF).

The PROC Definition:

ALTER PROC [appSec].[SubjectTreeNode_insert]

 @ID int OUTPUT,
 @SubjectTree int,
 @pRef int,
 @Title varchar(100),
 @Description varchar(250),
 @OrderWeight int,
 @ExpandState bit,
 @pRef2 int OUTPUT
 
AS
BEGIN

 INSERT INTO dbo.SubjectTreeNode (
  [SubjectTree],
  [pRef],
  [Title],
  [Description],
  [OrderWeight],
  [ExpandState]
 )
 VALUES (
  @SubjectTree,
  CASE WHEN @pRef2=@pRef THEN @pRef2 WHEN @pRef2 IS NOT NULL THEN @pRef2 ELSE @pRef END,
  @Title,
  @Description,
  @OrderWeight,
  @ExpandState
 )
 
 SELECT @ID=ID, @pRef2=pRef2 FROM dbo.SubjectTreeNode WHERE ID = SCOPE_IDENTITY()
END

The EntityType:

        <EntityType Name="SubjectTreeNode_appSec">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Type="Int32" Name="ID" Nullable="false" />
          <Property Type="Int32" Name="pRef" Nullable="false" />
          <Property Type="String" Name="Title" Nullable="false" MaxLength="100" />
          <Property Type="String" Name="Description" Nullable="true" MaxLength="250" />
          <Property Type="Int16" Name="OrderWeight" Nullable="false" />
          <Property Type="Boolean" Name="ExpandState" Nullable="true" />
          <Property Type="Int16" Name="IsTopLevel" Nullable="true" a:StoreGeneratedPattern="Computed" xmlns:a="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
          <NavigationProperty Name="SubjectTree_appSec" Relationship="edmTESTSCORING2.SubjectTree_appSecSubjectTreeNode_appSec" FromRole="SubjectTreeNode_appSec" ToRole="SubjectTree_appSec" />
          <NavigationProperty Name="SubjectTreeNodeAssoc_appSec" Relationship="edmTESTSCORING2.SubjectTreeNode_appSecSubjectTreeNodeAssoc_appSec" FromRole="SubjectTreeNode_appSec" ToRole="SubjectTreeNodeAssoc_appSec" />
          <NavigationProperty Name="SubjectTreeNode_appSec_children" Relationship="edmTESTSCORING2.SubjectTreeNode_appSecSubjectTreeNode_appSec" FromRole="SubjectTreeNode_appSec_parent" ToRole="SubjectTreeNode_appSec_children" />
          <NavigationProperty Name="SubjectTreeNode_appSec_parent" Relationship="edmTESTSCORING2.SubjectTreeNode_appSecSubjectTreeNode_appSec" FromRole="SubjectTreeNode_appSec_children" ToRole="SubjectTreeNode_appSec_parent" />
        </EntityType>

The EntitySet:

          <EntitySet Name="SubjectTreeNode_appSec" EntityType="edmTESTSCORING2.Store.SubjectTreeNode" store:Type="Views" store:Schema="appSec" store:Name="SubjectTreeNode_appSec">
            <DefiningQuery>
              SELECT TOP 100 PERCENT
              STN.[ID], STN.[SubjectTree], STN.[pRef], STN.[Title], STN.[Description], STN.[OrderWeight], STN.[ExpandState], STN.[IsTopLevel], STN.[pRef2]
              FROM
              appSec.SubjectTreeNode as STN
            </DefiningQuery>
          </EntitySet>

The Association:

        <Association Name="SubjectTreeNode_appSecSubjectTreeNode_appSec">
          <End Type="edmTESTSCORING2.SubjectTreeNode_appSec" Role="SubjectTreeNode_appSec_parent" Multiplicity="0..1" />
          <End Type="edmTESTSCORING2.SubjectTreeNode_appSec" Role="SubjectTreeNode_appSec_children" Multiplicity="*" />
        </Association>

The AssociationSet:

          <AssociationSet Name="SubjectTreeNode_appSecSubjectTreeNodeAssoc_appSec" Association="edmTESTSCORING2.SubjectTreeNode_appSecSubjectTreeNodeAssoc_appSec">
            <End Role="SubjectTreeNode_appSec" EntitySet="SubjectTreeNode_appSecs" />
            <End Role="SubjectTreeNodeAssoc_appSec" EntitySet="SubjectTreeNodeAssocs_appSec" />
          </AssociationSet>

The AssociationSetMapping:

          <AssociationSetMapping Name="SubjectTreeNode_appSecSubjectTreeNode_appSec" TypeName="edmTESTSCORING2.SubjectTreeNode_appSecSubjectTreeNode_appSec" StoreEntitySet="SubjectTreeNode_appSec">
            <EndProperty Name="SubjectTreeNode_appSec_children">
              <ScalarProperty Name="ID" ColumnName="ID" />
            </EndProperty>
            <EndProperty Name="SubjectTreeNode_appSec_parent">
              <ScalarProperty Name="ID" ColumnName="pRef2" />
            </EndProperty>
            <Condition ColumnName="pRef2" IsNull="false" />
          </AssociationSetMapping>

The EntitySetMapping (and the problem):

          <EntitySetMapping Name="SubjectTreeNode_appSecs">
            <EntityTypeMapping TypeName="IsTypeOf(edmTESTSCORING2.SubjectTreeNode_appSec)">
              <MappingFragment StoreEntitySet="SubjectTreeNode_appSec">
                <ScalarProperty Name="IsTopLevel" ColumnName="IsTopLevel" />
                <ScalarProperty Name="ExpandState" ColumnName="ExpandState" />
                <ScalarProperty Name="OrderWeight" ColumnName="OrderWeight" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="pRef" ColumnName="pRef" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
            <EntityTypeMapping TypeName="edmTESTSCORING2.SubjectTreeNode_appSec">
              <ModificationFunctionMapping>
                <InsertFunction FunctionName="edmTESTSCORING2.Store.SubjectTreeNode_insert" RowsAffectedParameter="ID">
                  <AssociationEnd AssociationSet="SubjectTree_appSecSubjectTreeNode_appSec" From="SubjectTreeNode_appSec" To="SubjectTree_appSec">
                    <ScalarProperty Name="ID" ParameterName="SubjectTree" /></AssociationEnd>
                  <AssociationEnd AssociationSet="SubjectTreeNode_appSecSubjectTreeNode_appSec" From="SubjectTreeNode_appSec_children" To="SubjectTreeNode_appSec_parent">
                    <ScalarProperty Name="ID" ParameterName="pRef2" /></AssociationEnd>
                  <ScalarProperty Name="ID" ParameterName="ID" />
                  <ScalarProperty Name="ExpandState" ParameterName="ExpandState" />
                  <ScalarProperty Name="OrderWeight" ParameterName="OrderWeight" />
                  <ScalarProperty Name="Description" ParameterName="Description" />
                  <ScalarProperty Name="Title" ParameterName="Title" />
                  <ScalarProperty Name="pRef" ParameterName="pRef" />
                  <ResultBinding Name="ID" ColumnName="ID" />
                  </InsertFunction>
                <UpdateFunction FunctionName="edmTESTSCORING2.Store.SubjectTreeNode_update" RowsAffectedParameter="pRef2">
                  <AssociationEnd AssociationSet="SubjectTreeNode_appSecSubjectTreeNode_appSec" From="SubjectTreeNode_appSec_children" To="SubjectTreeNode_appSec_parent">
                    <ScalarProperty Name="ID" ParameterName="pRef2" Version="Current" /></AssociationEnd>
                  <AssociationEnd AssociationSet="SubjectTree_appSecSubjectTreeNode_appSec" From="SubjectTreeNode_appSec" To="SubjectTree_appSec">
                    <ScalarProperty Name="ID" ParameterName="SubjectTree" Version="Current" /></AssociationEnd>
                  <ScalarProperty Name="ExpandState" ParameterName="ExpandState" Version="Current" />
                  <ScalarProperty Name="OrderWeight" ParameterName="OrderWeight" Version="Current" />
                  <ScalarProperty Name="Description" ParameterName="Description" Version="Current" />
                  <ScalarProperty Name="Title" ParameterName="Title" Version="Current" />
                  <ScalarProperty Name="pRef" ParameterName="pRef" Version="Current" />
                  <ScalarProperty Name="ID" ParameterName="ID" Version="Current" />
                  </UpdateFunction>
                <DeleteFunction FunctionName="edmTESTSCORING2.Store.SubjectTreeNode_delete">
                  <ScalarProperty Name="ID" ParameterName="ID" /></DeleteFunction></ModificationFunctionMapping></EntityTypeMapping>
          </EntitySetMapping>

The logc.dll being used by another process

Fri, 02 Oct 2009 15:21:17 Z

Hi,
Well I dont know it sounds really easy but I am not able to find the solution for it. The Problem is

" Unable to copy file "C:\skm\Ptx\Business\Logic\bin\Debug\Logic.dll" to "bin\Debug\Logic.dll". The process cannot access the file 'bin\Debug\Logic.dll' because it is being used by another process. "

Here is my code :
public class Logic
    {
        static Logic()
        { }
        public static void Init()
        {
            if (myModel != null)
                return;
            myModel = new Data.Model.GlobalEntities();
            myModel.ContextOptions.DeferredLoadingEnabled = true;
        }
        public static Logic.ProjectDS.ProjectEntities DSctx;

        public static IStudyCaseLogic studycaseLogic = new StudyCaseLogic();

        public static bool DataServices = false;

        public static Model.GlobalEntities myModel;

        public static void Dispose()
        {
            if (myModel == null)
                return;
            myModel.Dispose();

           myModel = null;

        }

So this code is working good first time. Then i change some just like press enter ramdomly and save the logic file build it again and it shows the error.
Some how it is not leaving the resources it aquire.

Any Help appreciated,
N

Mapping a foreign key participating in multiple relationships

Sun, 15 Nov 2009 19:23:09 Z

I have a large database with a subset of five tables described here:

http://www.senselessdestruction.com/AssociationProblem.jpg

When creating an entity model based on those tables I get the error:

Foreign key constraint 'FK_UserContractCompanies_TimesheetContractEntries' has been omitted from the storage model. Column 'CompanyId' of table 'SMSModel.Store.UserContractCompanies' is a foreign key participating in multiple relationships. A one-to-one Entity Model will not validate since data inconsistency is possible.

The intended business logic is to have a subset of users as contract users. A contract user arrives at the workplace, can sign in (an entry is made in the TimesheetEntries table), work for X hours and then sign out. For any user that is a contract user, the TimesheetContractEntries table exists to record their times broken into two records. The first record would be start and end times showing the first 8.5 hours of work, without a related ContractCompanyId, and the second record would be the remaining time with a related ContractCompanyId.

I'm using VS 2010 Beta 2, and have tried including foreign key columns in the model. Is the schema of my database flawed or is there anyway to overcome this limitation in the EF?

-Mike.

Should Disconnected / Self-Tracking Entities Fire the OptimisticConcurrencyException?

Fri, 20 Nov 2009 20:54:38 Z

I'm running concurrency tests with EF4 B2 Self-tracking entities and I can't get EF to throw the OptimisticConcurrencyException, even when I debug and inpect and see that the version about to be saved is different from the saved version. Is there any issue with self-tracking entities in this regard?

Thanks!

Model first development with POCO

Fri, 20 Nov 2009 20:14:22 Z

Hi,

I've just watched PDC 2009 Talk about EF.

You've showed how generated classes could be replaced with poco.

If I will change my POCO classes. How could i reflect those changes to database and mapping xml files.

Best regards,
Alexey Zakharov.

How To Use POCO Support in EF 4 To Modify a Query (VB)?

Fri, 20 Nov 2009 03:27:32 Z

I need to refine all EF queries to apply a business rule to one of the properties.

Can this be done using EF4's POCO support? Could someone show me some code that demonstrates this (VB preferred)?

Thks