.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

WCF - Basic Design Question Regarding No. Of Services vs No. of Tables

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :WCF


Let's say you have N tables, and you want to write CRUD as per table not in an OO fashio. 

How many WCF services are required?

is it near 5 * N (C,U,D, R and List with different criteria)? 

Or would you have 1 service that takes care of all the CRUD?

What would be the interface (parameters) passed to such a service.

The number does not really matter, in fact the only thing I care about is the architecture.

If you are not able to provide detailed answers, please point me to where I can learn more about this.

Thank you.



View Complete Post

More Related Resource Links

Basic question about web services


I followed an example on how to create a simple web service that converts celsius to fahrenheit. It seems to work alright. After the conversion it outputs the new value in xml. What do you do with the value that's in xml? Do you use an Xmlreader to read it from the xml, or what is usually done after the value is generated in xml?


Some basic MVC question

  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series


C# Soup To Nuts  (the best series ever)


I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?





Very Basic Question - Error message running first page


Hi Everyone,

I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.

The web application I am running was downloaded from the net (and has worked on other machines previously).  Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp

I am a bit of a novice at this!  But I am hoping someone can point me in the right direction!


I get the following error when I try and run the web application through IE:

"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."

(When i click the "click here" button it just goes to the IIS site).


Appreciate any help I can get!




database interface design question


For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.

Workflow Services: Visual Design of Workflows with WCF and WF 4


The .NET Framework 4 makes it easier than ever to implement WCF services using WF. We'll demonstrate just how easy it is by modeling a long-running, durable and instrumented workflow based on a real-world business case without having to write any code.

Leon Welicki

MSDN Magazine May 2010

Client ID basic question


Hi guys,

Is there any problem to use MANUALLY, within a Javascript, the client ID code?

Like that  ctl00_ContentPlaceHolderConteudo_pgtoiframe


I have one iFrame that need to access div style located in the parent page. So I've done that using manually the clientID code. The code works perfectly and It's still working fine right now.

Will I get errors or problems in the future using it in that manner????

Thank you


Basic question



           I m using VS 2005. When I create a website using VS 2005, it doesnt let me choose the solution folder it automatically creates the folder under My Document. Dont know why. I created website under say C:\Project\MyWebsite.


I have a page, with an image whose source is /image/xyz.gif. So I created a folder image under c:\Project\MyWebsite and have xyz.gif. But the page didnt show the image. If the image path is "image/xyz.gif" then it works. Isnt the directory that you create MyWebsite the root directory?.







SQL architecure basic question

Hey, I am new to SQL Server or RDBMS. I am a .Net developer. I would like to get SQL Server installed to my PC. I am seeing Microsoft SQL Server 2005 -> Configuration Tools in my Start Menu/Programs, which has server configuration, Error and usage reporting and Surface area configuration. What are they? Is SQL server already installed in my PC? I heard there are management studio but I am not seeing that. what are they? how do they work? any good article links to explain the basics? Thanks. -Jesu Benin.Software Professional

Basic Question on .NET CLR in SQL - Calling a function directly?

Hello, I have been reading up on CLR + SQL integration - My aim is to do an e-mail validation by calling RegEx functionality provided by the CLR.However from what I read and if I understand correct - I would need to create a .NET assembly and load it. I was wondering if there is an option to invoke .NET functions directly from SQL [e.g like create a function and access the .NET classes] . ?C# Fan! ananda84(at)gmail(dot)com

Bookmarking via Services Question

When I set a bookmark via a service?  Right now in my NativeActivity I CreateBookmark, then track the Activity so I know about pending bookmarks... But the problem with the darn service is that it freezes (waits for response?)...and it's not persisting to the DB.  Is this an option in the webconfig that I perhaps haven't set? :) ...and how do I go about RESUMING that bookmark? Thanks, Steve

I need a workflow triggered by a workflow...how do I design this? Beginner question

I've added the Approval workflow to a forms library and it generates the necessary tasks and emails for 2 levels (serial) of Approval on the form. When the form has been approved the 2nd time, I want it to trigger another workflow that notifies a 3rd person of the existence of the form and assigns her a separate non-approval task. I'm creating it in SharePoint Designer, and I can do most of it, but I'm not sure what field I'm looking for, at the beginning in order to start the workflow. Currently, there is no column for Approval Status in the form library, only a column that shows the status of the workflow (In Progress or Approved).  I tried If Workflow Status equals Approved then email.... but that didn't work. Any help is greatly appreciated.  I'm looking for the data source field and the list item field and value, I guess.  

SQL Server Tables and Exchange Web Services sample does not include email body

I've sucessfuly implemented the above, very useful example. However, I cannot work out how to include the Body of the email with the reast of the data. Can anyone shed some light for me? Thanks Robert

Basic Encryption Question

I have been looking at ways of encrypting querystrings and I have found a few good examples.. but, I just want some clarification on what is most often referred to as the EncryptionKey and the characters that are in that key....Is there basically an unlimited number of alphanumeric combinations that could be used in the following code as the encryption key, is there anything that someone should be CAREFUL about including in that key?thanks...using System.Security.Cryptography;private static string EncryptionKey = "!#$a54?3";/// other examples: "r0b1nr0y"///in a try-catch:key = System.Text.Encoding.UTF8.GetBytes(EncryptionKey.Substring(0, 8));DESCryptoServiceProvider des = new DESCryptoServiceProvider(); inputByteArray = Convert.FromBase64String(Input);

WCF and Entity Framework Design question

Should we be using Entity Framework entities as data contracts across the WCF Layer? If yes when why have the POCO support and code only been added to the Entity Framework? I was assuming it was with the purpose to remove the dependancy that the client will have on the database if the client depends on the Entities. If No, then does that mean we need to create Business Objects for each entity that exists in the entity framework model? Please advise. Thanks.Nilotpal

Quick basic question about TFS 2010

Is TFS a standalone platform or do I need to install SQL Server 2010 first?     Thanks, Joshua

Animation sample and basic XAML question.

I am trying to put into place the animation sample in http://msdn.microsoft.com/en-us/library/system.windows.media.animation.stringkeyframe.keytime.aspx It doesn't work. I have two questions. 1) The example lists both the XAML and the C# code. It doesn't seem that the two are tied together. In this example is the XAML and C# code just two ways of obtaining the same result? 2) When the Rectangle is constructed in the C# code the properties set and the delegate event 'Loaded' asssigned. How is this event triggered? Just for learning purposes I would like to have this rectangle move across the bounds of the application window when triggered and stop again under user control. I am not sure how to construct the restangle then have it tied to my main window. Thank you. Kevin

(basic) DESCENDANTS question (I think) :-)

I am trying to get (first level) DESCENDANTS' aggregation for two different hierarchy types and it seems that for parent-child hierarchies it works fine (first example) however for regular hierarchies (non parent-child) it does not work, returning the same level's data.  Am I missing something basic here? I would really like to get the aggregation working for non parent-child hierarchies but I'm stumped on the syntax or whether it is doable. thx much for any thoughts! Cos   --Adventure Works -- with Parent/Child Hierarchy -- works fine! with member measures.[Rollup Amount] as   Aggregate(Descendants([Account].[Accounts].CurrentMember,                                             1,                                             SELF),[Measures].[Amount]) select {[Measures].[Amount], measures.[Rollup Amount]      } on 0, nonempty([Account].[Accounts].levels(0).members,[Measures].[Amount]) on 1 from [Adventure Works]
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend