implement repository in asp.net mvc 5

Question

I got dbset for table Functions in database and FunctionsContext: dbContext. I am implementing repository. In my interface I have only one function at the movement "GetFunctions". I got stuck in implementing class; method "GetFunctions" where I need to call FunctionsContext to get all list of available functions title from database and then send to controller class

I am using mvc5 asp.net and entity framework

dbContext

public class FunctionsContext : dbContext
{
    public DbSet<App_Functions> Functions { get; set; }
}

model

[Table("Functions")]
public class App_Functions
{
    [Key]
    public int Function_ID { get; set; }

    [StringLength(50)]
    [Required]
    public string Title { get; set; }

    public int Hierarchy_level { get; set; }
}

Domain Class

public class Functions
{
    public Functions()
    {

    }

    public int Function_ID { get; set; }
    public string Title { get; set; }
    public int Hierarchy_level { get; set; }
}

IRepository

interface IFunctionRepository: IDisposable
{
    IQueryable<Functions> GetFunctions { get; }
}

IRepository Implementation class

public class FunctionRepository : IFunctionRepository
{
    private FunctionsContext fun_Context = new FunctionsContext();

    public IQueryable<Functions>GetFunctions
    {
      ?????????
    }
}

what I want to implement in IQueryableGetFunctions

using (var db = new FunctionsContext())
{
    var query = from b in db.Functions
                orderby b.Function_ID
                select b;

    foreach (var item in query)
    {
        var a2 = item.Title;
    }
}

in last section i have mansion what I want to implement in IQueryableGetFunctions — K.Z
– K.Z, Commented Dec 17, 2013 at 6:01
So what is the problem? What doesn't work? I don't understand what is the question... — Alexey Raga
– Alexey Raga, Commented Dec 17, 2013 at 6:05

Pavel Kutakov · Accepted Answer · 2013-12-17 13:46:50Z

1

I think the easiest way will be the following:

public IQueryable<Functions> GetFunctions()
{
    return fun_Context.Functions.Select(x=>new Functions {
                   Function_ID = x.Function_ID,
                   Title = x.Title,
                   Hierarchy_level = x.Hierarchy_level 
               });
}

edited Dec 17, 2013 at 13:46

answered Dec 17, 2013 at 6:26

Pavel Kutakov

9711 gold badge7 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

K.Z Over a year ago

this is giving me error on return; "A Get or Set Accessor is Expected"

Pavel Kutakov Over a year ago

Sorry, forgot () near the method name

rad · Accepted Answer · 2013-12-17 08:43:17Z

1

You have to add () after the method name, this declaration does not work 'public IQueryable GetFunctions'

IRepository Implementation class

public class FunctionRepository : IFunctionRepository
{
    private FunctionsContext fun_Context = new FunctionsContext();

    // For method declaration add the () after the method name
    public IQueryable<Functions> GetFunctions()
    {
        return fun_Context.Functions;
    }
}

answered Dec 17, 2013 at 8:43

rad

1,9572 gold badges20 silver badges32 bronze badges

Collectives™ on Stack Overflow

implement repository in asp.net mvc 5

dbContext

model

Domain Class

IRepository

IRepository Implementation class

what I want to implement in IQueryableGetFunctions

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

dbContext

model

Domain Class

IRepository

IRepository Implementation class

what I want to implement in IQueryableGetFunctions

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related