Re: System Architecture / .NET Remoting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Sam,

SS> I guess
SS> I'm looking for more information how people commonly "encapsulate
SS> all
SS> our business logic in remote components running on an
SS> application server" Also, I was trying to determine if the best way
SS> to connect our webservers or any other clients to the application
SS> server is though the .NET Remoting Framework. This is all new to
SS> me....

It's not purely true that all business logic should be removed fromt the stored procedures. Some of them should present. There is no strict rules of what should or shouldn't be in stored procedures vs business logic in middleware. It completely depends on one's application.
I'd recommend to read http://msdn2.microsoft.com/en-us/library/ms978496.aspx and http://www.codeproject.com/gen/design/DudeWheresMyBusinessLogic.asp where you can find out some recomendations.

What about remoting - consider using WCF to buid your services and some workflow engines like MS WF or even BizTalk

---
WBR, Michael Nemtsev [.NET/C# MVP]. My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we miss it, but that it is too low and we reach it" (c) Michelangelo


.

Relevant Pages

  • Re: Business Rules & Referential Integrity
    ... With regards to my stored procedures and the inherent "White Elephant", ... fully appreciate your comments and will use Declared Referential Integrity ... in SQL Server and capture any named constraint errors/exceptions this way. ... >> about application design and implementation using DotNet. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... server compares the parameter values to the date of the creation of the SP, ... > 1) you can set the record source to the name of a SP, ... > Sylvain Lafontaine, ing. ... >> I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Permissions???
    ... > Server: SQL Server 2000. ... > the user could Write/Read data from server and execute stored procedures. ... > The connection was made with DSNs. ... ADO gives the following message when using stored ...
    (microsoft.public.data.ado)
  • Re: Help!!!
    ... Ensure your stored procedures include 'SET NOCOUNT ON'. ... > Server: SQL Server 2000. ... > I had an ADO conection to the from a VB Application, ... > The connection was made with DSNs. ...
    (microsoft.public.sqlserver.security)
  • Re: DB design, facilitates Double entries of internal transactions
    ... The single server is also ... transactions, even if just a pair of ID's/amounts, is still double entry. ... but I would tend to recommend SQL Server ... Stored Procedures and transaction control on the server. ...
    (microsoft.public.access.tablesdbdesign)