Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Converting Linq to Sql query to Linq to entity

Converting Linq to Sql query to Linq to entity

Scheduled Pinned Locked Moved ASP.NET
databasecsharplinqhelptutorial
2 Posts 1 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Swiftain
    wrote on last edited by
    #1

    Hi, I tried running the following linq to sql query in linq to entity

            var req = dbContext.Requisitions.First(r=>r.ID==new Guid(Request\["ReqID"\]));
    

    I got the following error "Only parameterless constructors and initializers are supported in LINQ to Entities." Any ideas how to go about this? Thanks

    S 1 Reply Last reply
    0
    • S Swiftain

      Hi, I tried running the following linq to sql query in linq to entity

              var req = dbContext.Requisitions.First(r=>r.ID==new Guid(Request\["ReqID"\]));
      

      I got the following error "Only parameterless constructors and initializers are supported in LINQ to Entities." Any ideas how to go about this? Thanks

      S Offline
      S Offline
      Swiftain
      wrote on last edited by
      #2

      Got a work around, did something like this

              Guid ReqID = new Guid(Request\["ReqID"\]);
              
              var req = dbContext.Requisitions.First(r => r.ID == ReqID);
      
      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups