Re: Tips for improving efficiency?



Ben R. wrote:
Hi all,

I'm soon to overhaul my asp.net 2.0's backend data source. My plans:

-To implement a data access layer
-To move from access to SQL Server 2005.

I'm going to be implementing just about every provider that microsoft
ships for sql server (membership, profile, etc).

In addition to any general advice, I've got a specific question: I've
got a page with several user controls, some of which operate on
similar data. Would it make sense to fill a dataset and then cache it
somehow and pass it around? Would this be done in the data access
layer?

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.



Relevant Pages

  • Deploying Access Data Pages
    ... I am connecting to a SQL Server database with a Data ... While deploying the data access page in other machines, ...
    (microsoft.public.sqlserver.security)
  • Re: Binding Access Forms to a SQL Server Data source : View Or Sto
    ... Goldmine on SQL with 12 users. ... On the same SQL Server, ... It still uses BDE for data access. ... My form source is a Stored Procedure that returns ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL server vs mySQL ???
    ... The easiest way to support multiple databases is to work with a data access ... This question changes depending on which version of MySQL one has. ... * SQL Server has richer trigger support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problems with remoting and SqlCommand.ExecuteNonQuery
    ... self-signed certificates and SQL Server which may be affecting you (since ... > I´m having problems with a .net remoting application. ... > is a data access component, in other words, it performs data access tasks. ... > The problem arise when I try to execute a database task which involves the ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: How do you connect to SQL server using SQL users with Windows Auth? help
    ... the domain and the data access will work. ... you can add an IUSR_MachineName account to the SQL Server with the ... "Reza" wrote in message ... > I am able to connect with the same user but with SQL Authentication ...
    (microsoft.public.dotnet.framework.aspnet)