Cannot implicitly convert System.Linq.IQuerayable to xxx

[daniel50096230]

Hi,

I had the following codes:

  [ResponseType(typeof(cvwSMSInbox))]
        public IHttpActionResult GeteSMSInbox(string id, string search)
        {
            AESContext db = new AESContext(id);

            cvwSMSInbox record = new cvwSMSInbox();

             record = db.cvwSMSInbox.Where(s => s.Branch_ID == search);
   
            return Ok(record);
        }

I got the error below:

Cannot implicitly convert type 'System.Linq.Iqueryable<cvwSMSInbox>' to 'cvwSMSInbox'. An explicit conversion exists.

Any help is kindly appreciated.

[Arjay]

Replace the .Where with .SingleOrDefault.