How to run normally query script in entity framework mvc c#

Question

I have face problem about entity framework in mcv c#, i decide to change the way to exec query to normally query scripting, this bellow script I have for exemple

//for only one row result
string activeUser = await db.Users.Where(x => x.Token.Equals(token)).Select(x => x.Username).FirstOrDefaultAsync();

ReceivingSFG receiving = await db.ReceivingSFGs.Where(s => s.ID.Equals(receivingVM.ID)).FirstOrDefaultAsync();


//for multiple row result (List)
IQueryable<ReceivingSFGDetail> query = db.ReceivingSFGDetails.Where(s => s.ReceivingID.Equals(req.ID)).AsQueryable();
            IEnumerable<ReceivingSFGDetail> list = Enumerable.Empty<ReceivingSFGDetail>();
            list = query.ToList();
            IEnumerable<ReceivingSFGDetailDTO> listDto = Enumerable.Empty<ReceivingSFGDetailDTO>();
            string message = "";
            bool status = false;
            listDto = from x in list
                   select new ReceivingSFGDetailDTO
                   {
                       ID = x.ID,
                       ReceivingID = x.ReceivingID,
                       Barcode = x.Barcode,
                       QtyActual = x.QtyActual,
                       QtyBag = x.QtyBag,
                       CreatedBy = x.CreatedBy,
                       CreatedDate = x.CreatedDate,
                       QtyPerBag = x.QtyPerBag
                   };

or some case that I never use before, like how to exec store procedure... please some one can help me to solve this case.

gardarvalur · Accepted Answer · 2020-11-28 10:46:43Z

0

If you want to execute Stored Procedure vie Entity framework you will of course have to start by mapping it into the data context.

Once the stored procedure is mapped in your model layer you can simply call it pseudo like this:

List<SomeStuff_Result> list = _db.NameOfStoredProcedure(string somevariable).ToList();

It should behave the same way any object you receive from data layer.

You can also check this answer.

answered Nov 28, 2020 at 10:46

gardarvalur

1,5859 gold badges40 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

How to run normally query script in entity framework mvc c#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related