Entity Framework 6 - Knowledge Base (KB)

How to get row number via LINQ using Entity framework?

Hope someone can help me out here as I'm a little stuck....I'm building a service in front of a hiscore database for a game....The database have the following two tables:...CREATE TABLE [dbo].[PB_HiscoreEntry] ( [Id] UNIQUEIDENTIFIER NOT NULL...

Entity framework: How to return a row from a table with composite keys?

public class UserBuilding { [Key, Column(Order = 0)] public int UserId { get; set; } [Key, Column(Order = 1)] public int BuildingId { get; set; } public int BuildingLevel { get; set; } } ...If I wanted to ...

Entity framework and stored procedure with output parameter returning row (EF will receive complex type)

I am using entity framework 6 with stored procedures. Currently I deal with this problem:...Ideally I need to get data from one stored procedure. This data includes: One Conversation (basic info) + multiple Clients (which are engaged in this conversation)...