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. General Programming
  3. LINQ
  4. Except

Except

Scheduled Pinned Locked Moved LINQ
helplinqcsharpcom
5 Posts 2 Posters 3 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.
  • M Offline
    M Offline
    murali_utr
    wrote on last edited by
    #1

    var resv = (from S in qryGen.T_RESV_DETAILs select new { S.F_RESV_ID, S.F_RESV_NUMBER }).Except (from O in qryGen.T_Offers join R in qryGen.T_RESV_DETAILs on O.F_Resv_Id equals R.F_RESV_ID select new { O.F_Resv_Id, R.F_RESV_NUMBER }); I found following Compilation Error. The type arguments for method 'System.Linq.Queryable.Except<TSource>(System.Linq.IQueryable<TSource>, System.Collections.Generic.IEnumerable<TSource>)' cannot be inferred from the usage. Try specifying the type arguments explicitly. Any one help to come out from problem. Thanks in Advance!

    Have A Nice Day! Murali.M Blog

    J 1 Reply Last reply
    0
    • M murali_utr

      var resv = (from S in qryGen.T_RESV_DETAILs select new { S.F_RESV_ID, S.F_RESV_NUMBER }).Except (from O in qryGen.T_Offers join R in qryGen.T_RESV_DETAILs on O.F_Resv_Id equals R.F_RESV_ID select new { O.F_Resv_Id, R.F_RESV_NUMBER }); I found following Compilation Error. The type arguments for method 'System.Linq.Queryable.Except<TSource>(System.Linq.IQueryable<TSource>, System.Collections.Generic.IEnumerable<TSource>)' cannot be inferred from the usage. Try specifying the type arguments explicitly. Any one help to come out from problem. Thanks in Advance!

      Have A Nice Day! Murali.M Blog

      J Offline
      J Offline
      Judah Gabriel Himango
      wrote on last edited by
      #2

      I can't answer your question because I don't know what type T_RESV_DETAILs is Your query seems a little odd. Tell us what you're trying to do, then perhaps we can help you out with your query.

      M 1 Reply Last reply
      0
      • J Judah Gabriel Himango

        I can't answer your question because I don't know what type T_RESV_DETAILs is Your query seems a little odd. Tell us what you're trying to do, then perhaps we can help you out with your query.

        M Offline
        M Offline
        murali_utr
        wrote on last edited by
        #3

        Thanks for your reply. T_Resv_Details is a table name.

        Have A Nice Day! Murali.M Blog

        J 1 Reply Last reply
        0
        • M murali_utr

          Thanks for your reply. T_Resv_Details is a table name.

          Have A Nice Day! Murali.M Blog

          J Offline
          J Offline
          Judah Gabriel Himango
          wrote on last edited by
          #4

          I know it's a table name. What type is coming back from that table? Better yet, tell us what you're trying to do and we may be able to better craft a query.

          Life, family, faith: Give me a visit. From my latest post: "A lot of Christians struggle, perhaps at a subconscious level, about the phrase "God of Israel". After all, Israel's God is the God of Judaism, is He not? And the God of Christianity is not the God of Judaism, right?" Judah Himango

          M 1 Reply Last reply
          0
          • J Judah Gabriel Himango

            I know it's a table name. What type is coming back from that table? Better yet, tell us what you're trying to do and we may be able to better craft a query.

            Life, family, faith: Give me a visit. From my latest post: "A lot of Christians struggle, perhaps at a subconscious level, about the phrase "God of Israel". After all, Israel's God is the God of Judaism, is He not? And the God of Christianity is not the God of Judaism, right?" Judah Himango

            M Offline
            M Offline
            murali_utr
            wrote on last edited by
            #5

            Retriving Two columns on RESV_ID and RESV_NUMBER. RESV_ID in integer and RESV_NUMBER is varchar(50). Thanks

            Have A Nice Day! Murali.M Blog

            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