I have a win form that needs to access SQL server to retrieve data. Winform will be distributed to customer and we do SQL server hosting. Currently, my Winform accesses SQL server directly without middleware. I’d like to develop a middle tier as a data provider. My question is:

-What’s the common architecture for the middleware?

Notes:
-The data for each request from win form is about 200KB.
- I don’t really like to use web service as it is very slow.
-Is MSMQ a good option?
-Data being transfer is custom objects and HTML files
- Data should be available in real-time (sync calls)

I know you said no webservices, but i would still recommend it.

You could use AD.NET Data Services, or WCF Services if you need very custom objects, with Asynchronous calls. 200KB should be easy for that. Also HTML is not a problem.

---

VB.NET to C# http://www.developerfusion.com/tools/convert/vb-to-csharp/

Hi CodesCrawler,

 

Do you use the application in the intranet or internet?

 

Based on my experience, web service has good ability to work on complicate network condition (internet as well as intranet with firewall). It is also widely used for large-scale situation. If you use the application only inside your company (intranet only), you can consider of .NET Remoting. Remoting has good performance, but the client users should in the same network and server side without firewall.

 

I think Se3ker has already given you some good suggestion. If you want any professional ideas on architecture, you can try to post the question on Architecture forums. The engineers on that forum are good at it.

 

Please tell us if you have any further question. Hope you can get some helps from our support.

 

Sincerely,

Kira Qian

Send us any feedback you have about the help from MSFT at EMAIL REMOVED

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework!