Entity Framework 4 Returning KEY/Primary Key

Entity Framework 4 Returning KEY/Primary Key

I’m Trying to find a way to Return a Key/Primary Key without having to create a stored procedure to do it for me using:

CREATE 开发者_Go百科PROCEDURE [dbo].[UserRecords]
(
    @Name   varchar(10)
) AS

-- INSERT the new record
INSERT INTO MyTable (Name)
VALUES(@Name)

-- Now return the InventoryID of the newly inserted record
SELECT SCOPE_IDENTITY() AS ID

Though Visual Studio 2010 I then Use the Add Function Import From the Model Browser and Create a Complex Type.

Then Though C# i use the Following Code to check its working.

 SQL_DB_Entities DB= new SQL_DB_Entities();
            var ReturnValue = DB.UserRecords("BOB").First();
            Console.Write(ReturnValue.ID);
            Console.Read();

I'm simply looking for a better way to return the ID and also being very sure im not going to cause head aches for myself laster on down the track.

If you feel this is not the best way to return the key please let me know.

I have Tried it this way but returns 0

SQL_DB_Entities DB = new SQL_DB_Entities();
User UserObject = new User{Name = “BOB”};
DB.AddToUserTable(UserObject);
DB.SaveChanges(): 
Int key = UserObject.ID;
Console.WriteLine(key.ToString()); 

I should also mention that the DB is looking after the Primary Keys not my application.

If you correctly setup StoreGeneratedPattern to Identity in your entity and if you have autogenerated PKs in the database, EF will fill the Ids of your inserted entities after each save changes. Check this article to understand store generated pattern.

Normally PKs are dealt with as a particular property on an EF Object EntityKey. You are probably best to have a look at EntityKeys.

The usual way is to set the StoreGeneratedPattern property of the PK column in your model as Identity. Or if you are using code-first, annotate the property with:

[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] 

I am not sure whether this works with sprocs, though. By the way, any special reason you are using sprocs in this case?