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. WCF and WF
  4. WCF -- How to access DAL.

WCF -- How to access DAL.

Scheduled Pinned Locked Moved WCF and WF
helpcsharpwcfdesigntutorial
5 Posts 2 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.
  • A Offline
    A Offline
    Alim12345
    wrote on last edited by
    #1

    Hi Guys, I have a small requirement. Please can any one help me?? Req: I have a UI---WCFService---DAL. From UI on button click i have 2 access WCF Service which will access DAL and fill my GridView... Plz can one help me for this... I tried but :(( some error coming in WCF Service...

    R 1 Reply Last reply
    0
    • A Alim12345

      Hi Guys, I have a small requirement. Please can any one help me?? Req: I have a UI---WCFService---DAL. From UI on button click i have 2 access WCF Service which will access DAL and fill my GridView... Plz can one help me for this... I tried but :(( some error coming in WCF Service...

      R Offline
      R Offline
      Ravi Mori
      wrote on last edited by
      #2

      Can you explain what error comes??

      A 1 Reply Last reply
      0
      • R Ravi Mori

        Can you explain what error comes??

        A Offline
        A Offline
        Alim12345
        wrote on last edited by
        #3

        This function declaration i am using in Interface [OperationContract] ISingleResult Spr_GetEmployerDetails(); Class Implementation public ISingleResult Spr_GetEmployerDetails() { //DBHelperDataContext db = new DBHelperDataContext("Data Source=10.105.103.112;Initial Catalog=esic;Persist Security Info=True;User ID=esicpoc;Password=pass@word1"); ISingleResult Emplist = db.Spr_GetEmployerDetails(); return Emplist; } after this i ran in wcfclientteest myservice the error is (the operation is not supported in the WCF).. with red mark

        R 1 Reply Last reply
        0
        • A Alim12345

          This function declaration i am using in Interface [OperationContract] ISingleResult Spr_GetEmployerDetails(); Class Implementation public ISingleResult Spr_GetEmployerDetails() { //DBHelperDataContext db = new DBHelperDataContext("Data Source=10.105.103.112;Initial Catalog=esic;Persist Security Info=True;User ID=esicpoc;Password=pass@word1"); ISingleResult Emplist = db.Spr_GetEmployerDetails(); return Emplist; } after this i ran in wcfclientteest myservice the error is (the operation is not supported in the WCF).. with red mark

          R Offline
          R Offline
          Ravi Mori
          wrote on last edited by
          #4

          sorry i don't understand your code. My doubts are: 1)What is ISingleResult?Is that interface? 2)In Which line this error comes?

          A 1 Reply Last reply
          0
          • R Ravi Mori

            sorry i don't understand your code. My doubts are: 1)What is ISingleResult?Is that interface? 2)In Which line this error comes?

            A Offline
            A Offline
            Alim12345
            wrote on last edited by
            #5

            Ok let me explain my requirement... I have one button and one grid On button cliek i have 2 fill employee details... using WCF I tuk button, grid.. Now I wrote WCF code which will access DAL layer... In DAL I used LinqtoSQLClass.. I want to return one dataset from DAL to WCF which will return 2 my UI and it will fill my Grid. So to get data from DAL I used as I cant use LinqtoSQLClass functions directly from my UI. public ISingleResult Spr_GetEmployerDetails() { ISingleResult Emplist = db.Spr_GetEmployerDetails(); return Emplist; } So the return type is ISingleResult.... Or Can U suggues how can i do ? UI---WCF---DAL UI(Grid)----WCF(Access DAL)---------DAL(Contain all employee database in LinqtoSQLClass) Thanks & Regards Alim

            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