Dawa,
If you're concerned about the success of building a C# app, just go to monster.com and look up VFP jobs in our area and look up C# apps in our area. Look at some of the descriptions for the type of work going on in C#. Boatloads of client/server desktop apps.
If you're looking for some good ideas on architecture read "Expert C# Business Objects" by Rockford Lhotka. This will clear up many if not all of your questions/concerns. Of course it will open another set of questions, but that's a different story.
>Thanks for everybody who replied to me on the topic of "Application Architecture".
>After my conversation with Jordan. I'm wondering if there is any successful Client/Server .NET application with MS SQL as backend and the .NET application as the client application. If anybody could share their success stories or failure stories, I would be most grateful!
(On an infant's shirt): Already smarter than Bush