How to execute function in MVC with Entity Framework?

Question

how to use following function

Generic Function:

public T GetSingle(Expression<Func<T, bool>> whereCondition)
       {
           return this.ObjectSet.Where(whereCondition).FirstOrDefault<>();
       }

Business logic wise:

//Now in the following function i would like to call Generic function.

public TabMasterViewModel GetSingle(Expression<Func<TabMasterViewModel, bool>> whereCondition)
       {

           _tabmasterRepository.GetSingle( .. what should be here.. );
       }

//Calling function from Controller level.

public ActionResult Details(int id)
       {
           return View(_tabmasterService.GetSingle(x => x.colID == id));
       }

I could not able to use the function, please suggest.

_tabmasterRepository.GetSingle( .. what should be here.. );

Thanks, Imdadhusen

possible duplicate of How to execute function? which type of paramter should? — Jakub Konecki
– Jakub Konecki, Commented Jun 4, 2011 at 9:31
yes i have implemented code as suggested by you at the Controller level return View(_tabmasterService.GetSingle(x => x.colID == id)); but the i also have to pass the GetSingle to the Generic Function — imdadhusen
– imdadhusen, Commented Jun 4, 2011 at 9:44
the follow is like calling function from Controller >> Base >> Generic. and i have problem in Base — imdadhusen
– imdadhusen, Commented Jun 4, 2011 at 10:31

Eranga · Accepted Answer · 2011-06-04 10:41:56Z

1

Either you modify your first generic function as

public T GetSingle(Expression<Func<T, bool>> whereCondition)
{
     return context.CreateObjectSet<T>().Where(whereCondition).FirstOrDefault();
}

or create a genetic repository

public class RepositoryGeneric<TEntity>
{
    public RepositoryGeneric(Context context)
    {
        Context = context;         
    }

    protected ObjectContext Context { get; private set; }

    protected virtual ObjectSet<TEntity> ObjectSet
    {
        get { return Context.CreateObjectSet<TEntity>(); }
    }

    public virtual TEntity GetByKey(params object[] keys)
    {
        return DbSet.Find(keys);
    }

    public TEntity GetSingle(Expression<Func<TEntity, bool>> whereCondition)
    {
        return ObjectSet.Where(whereCondition).FirstOrDefault();
    }
}

Edit:

using the generic function

TabMasterViewModel model = _tabmasterService.GetSingle(x => x.colID == id);

or using generic repository

var tabmasterRepository = new RepositoryGeneric<TabMasterViewModel>(new Context());
var model = tabmasterRepository.GetSingle(x => x.colID == id);

edited Jun 4, 2011 at 10:41

answered Jun 4, 2011 at 9:43

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

2 Comments

Eranga Over a year ago

edited it to add an example. is entity type different from TabMasterViewModel?

imdadhusen Over a year ago

No it same for TabMasterViewModel

Collectives™ on Stack Overflow

How to execute function in MVC with Entity Framework?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related