Re: A good asp.net architecture for a large project (sort of newbie)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gopal \(FMS, Inc.\) (gopal_NOSPAM_at_fmsinc.com)
Date: 02/03/05


Date: Thu, 3 Feb 2005 10:38:06 -0500


> 1. What would be the best programming architecture for a large project
(300+
> tables) that needs to connect to any
database(access,sqlserver,mysql,oracle)
> as main database? Some code sample would be greatly appreciated (email:
> "info at improve. co. cr")
    I would recommend a layer for data-access, a layer for the business
objects and the ASP.NET presentation layer. If the website will have high
traffic, look up caching, design sessions carefully and keep it simple.

> 2. What would be the most efficient way to display large trees in asp.net?
> (tried a 3d party grid control that loaded everything staticly and took a
> LOT of time)
 http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=75&tabindex=2
describer Microsoft IE treeview control and how to use it. You may want to
design a proof of concept and then implement it on your system.

> 3. Is it better to use Web Services or Dlls for data access?
 Will the data be required by other applications over the internet? If yes,
go with a web service. If the answer is no, dlls should be just fine. You
can always write web service wrappers around the dlls later if there is a
need for web services.

Hope this helps.

-- 
Gopal Rangaswamy
Microsoft Certified Solutions Developer
FMS, Inc.
<http://www.fmsinc.com/consulting>
<http://www.fmsinc.com/dotnet/SourceBook/>
"Gus" <nospam@die.spam.die> wrote in message
news:epi$1AZCFHA.444@TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm helping a software development business to upgrade a (VB6 to Asp.net)
> commercial software they sell.
> We wanted to know what would be the best architecture(in ASP.NET) to use
as
> base for this large project.
> Especifically, the current application uses any (odbc) database and
displays
> trees of information for "Balance Scorecards".
>
> So this are the questions:
> 1. What would be the best programming architecture for a large project
(300+
> tables) that needs to connect to any
database(access,sqlserver,mysql,oracle)
> as main database? Some code sample would be greatly appreciated (email:
> "info at improve. co. cr")
> 2. What would be the most efficient way to display large trees in asp.net?
> (tried a 3d party grid control that loaded everything staticly and took a
> LOT of time)
> 3. Is it better to use Web Services or Dlls for data access?
>
> Thanks for your help
> Gus
>
>
>


Relevant Pages

  • Re: WebServices and Datasets
    ... And if I call the GetChanges Method on the dataset that only the ... be shown in the dataset and to pass that to the web service, ... "Now to make sure the remote database is updated with changes should I ... client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: REPOST: One Web Service updates SQL, the other cant
    ... One Web Service can access and update the database via ADO ... > possible using the following connection string: ... > Columnist, SQL Server Professional ...
    (microsoft.public.vb.database.ado)
  • Re: Synchronizing a SqlCE database on PocketPC
    ... Chris Tacke, Embedded MVP ... CE database and my remote database) from the VB.NET 2005 application that ... runs on that desktop instead of running it on the handheld. ... You may also want to check that you can connect to the web service ...
    (microsoft.public.pocketpc.developer)
  • Re: Just tell me why ? so confuse...
    ... What do you mean by WebService class should not directly access to database? ... I have created a WebService project ... Do you mean that inside my web service project I should add a separate ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: WSE 3.0 Running under default ASPNet user
    ... UsernameTokenManager which needs to access a remote database. ... The web service needs to access a database on a remote server, ... use the UserID and Password held in the IIS config; ... this would be using the NetworkService account on Server 2003. ...
    (microsoft.public.dotnet.framework.webservices.enhancements)