c# - GET api controller generating errors when eager loading -


i'm trying setup api controller in .net core pass model json jquery datatable keep getting connection errors when try eager load related model.

/api/projectscontroller.cs

using system.collections.generic; using system.linq; using system.threading.tasks; using microsoft.aspnetcore.http; using microsoft.aspnetcore.mvc; using microsoft.entityframeworkcore; using projectlogic.models;  namespace projectlogic.controllers.api {     [produces("application/json")]     [route("api/projects")]     public class projectscontroller : controller     {         private readonly projectlogicdbcontext _context;          public projectscontroller(projectlogicdbcontext context)         {             _context = context;         }          // get: api/projects         [httpget]         public async task<ienumerable<project>> getprojects()         {             var projects = await _context.projects                 //.include(p => p.pmemployee)                 .tolistasync();              return projects;         }          // get: api/projects/5         [httpget("{id}")]         public async task<iactionresult> getproject([fromroute] int id)         {             if (!modelstate.isvalid)             {                 return badrequest(modelstate);             }              var project = await _context.projects                 //.include(p => p.pmemployee)                 .singleordefaultasync(m => m.projectid == id);              if (project == null)             {                 return notfound();             }              return ok(project);         }     }     ... }

i tried setting same syntax in get: api/projects/id thinking erroring out on data running on entire project table employee model linked, isn't case. if uncomment .include(p => p.pmemployee) entry on either method, err_connection_reset if inspect page in chrome. running api url through rested extension gives me "an error occured while fetching resource: typeerror: failed fetch". comment line back, save, build, refresh request , works against _context.projects.

project.cs

using system; using system.collections.generic;  namespace projectlogic.models {     public class project     {         public project()          public int projectid { get; set; }         public string projectname { get; set; }         public int? pmemployeeid { get; set; }         public employee pmemployee { get; set; }         ...     } }

employee.cs

using system.collections.generic;  namespace projectlogiccore.models {     public class employee     {         public employee()         { pmprojects = new hashset<project>(); }          public int employeeid { get; set; }         public int employeetitleid { get; set; }         public string name { get; set; }         public icollection<project> pmprojects { get; set; }         ...     } }

the classes work fine eager loading non-api controller handling other views , viewmodels , i've got separate project identical syntax in api controller works fine eager loading. can't figure out tripping httpget api.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more