c# - Exception Fetching db data in WEBAPI controller in asp.net -

c# - Exception Fetching db data in WEBAPI controller in asp.net -

i trying homecoming info client page using webapi. please see below exception seeing while trying access api/controller browser

stacktrace system.runtime.serialization.xmlobjectserializerwritecontext.serializeandverifytype(datacontract datacontract, xmlwriterdelegator xmlwriter, object obj, boolean verifyknowntype, runtimetypehandle declaredtypehandle, type declaredtype) @ system.runtime.serialization.xmlobjectserializerwritecontext.serializewithxsitypeattoplevel(datacontract datacontract, xmlwriterdelegator xmlwriter, object obj, runtimetypehandle originaldeclaredtypehandle, type graphtype) @ system.runtime.serialization.datacontractserializer.internalwriteobjectcontent(xmlwriterdelegator writer, object graph, datacontractresolver datacontractresolver) @ system.runtime.serialization.datacontractserializer.internalwriteobject(xmlwriterdelegator writer, object graph, datacontractresolver datacontractresolver) @ system.runtime.serialization.xmlobjectserializer.writeobjecthandleexceptions(xmlwriterdelegator writer, object graph, datacontractresolver datacontractresolver) @ system.runtime.serialization.datacontractserializer.writeobject(xmlwriter writer, object graph) @ system.net.http.formatting.xmlmediatypeformatter.<>c__displayclass7.<writetostreamasync>b__6() @ system.threading.tasks.taskhelpers.runsynchronously(action action, cancellationtoken token)

controller method returns quotes

// api/<controller> private forumdbdatacontext db = new forumdbdatacontext(); public dynamic getquotes() { var ret = (from qt in db.vwusersquotess.tolist() select new { message = qt.desc, price= qt.price, qty = qt.quantity }).asenumerable(); homecoming ret; }

try utilize tolist() instead of asenumerable():

public dynamic getquotes() { var ret = (from qt in db.vwusersquotess select new { message = qt.desc, price= qt.price, qty = qt.quantity }).tolist(); homecoming ret; }

if utilize entityframework , sql server can remove phone call vwusersquotess.tolist() , projection (select new...) straight on sql server, query beingness executed retrieves necessary columns (desc, cost , quantity).

c# asp.net asp.net-web-api