SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database access through WCF services

    I've built an application using c# .net and sql. i connected the front end to the database directly through connection strings. Now I have to migrate that version to a 3 tiear application that uses WCF in windows services to access the database. Does anyone have a clue how to go about this? Or can you point me to a site that will have a solution.

  2. #2
    SitePoint Wizard
    Join Date
    Feb 2007
    Posts
    1,274
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1) create a new windows service project for the WCF tier.
    2) migrate the logic into this project by defining interfaces for services and data contracts.
    3) implement the logic classes in the WCF tier. Create backing classes for datacontracts. Implement the database querying and updating here. Obtain the connectionstring from the config file.
    4) implement the service so that it hosts the service contracts.
    5) refactor the web tier to use the WCF tier instead of database connections.
    6) profit.

  3. #3
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    err yeah. That would probably be useful to someone who already knew how to work with wcf. That was a very high level description. Is there anyway you could be a little more specific.

  4. #4
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,653
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    I suspect you are in a bit over your head here. This isn't exactly the sort of cut and dried thing that lends itself to an easy 3-page internet solution. First place to start--making the app truly 3-tier. Once you have that nailed, the rest is comparatively easy.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •