Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search


C# - Very Slow Web Application Which Use LINQ To SQL?

I am developing sample web application which use C#, and LINQ to SQL. The application is very very slow and it takes about 2 secs to navigate between pages. I have already used SQL Profiler and monitor the calls to the SQL server. All SQLs looks normal to me and their execution time is always about 1 or 2 millisecs.I tried the same application in another PC and it is the same. So, it is not because of my computer performance.

View 3 Replies (Posted: Jul 17 10 at 12:42)

Sponsored Links:

Related Forum Messages For ASP.NET category:
ADO.NET :: LINQ To SQL Very Slow Website?
Ihave created a website with 3.5 and c# (using linq to sql).its a basically a project managment system. bt its very slow when u look at its loading time. my dashboard takes a whole lot of time to load.when i look at other sites created by my colleagues it loads much faster than my site. they have developed it using + Stored procedures. that made me believe that linq to sql is slower than + SP improve mysite perfomance using linq to sql.

Posted: Oct 09, 2010 07:16 AM

View 4 Replies!   View Related
MVC :: LINQ Query Very Slow (only The First Time)?
I'm facing performance problems in my MVC application. The view is displaying a table with 150 rows, the data is collected in the controller. In the controller function, I'm using LINQ to SQL to get the data from tables stored in MS SQL 2005 server.Loading of the view takes far too long, approx. 10 seconds. The same when I reload the page - 10 seconds again. Now the stange thing:


The LINQ call seems to take a long time only the first time I call it inside the controller funtion, a second, third etc. call is much faster.My first guess was that there is something cached, so the second call is much faster. But when I reload the view, the cache seems no longer exist because it takes 10 seconds again.

Posted: Dec 17, 2009 06:45 AM

View 4 Replies!   View Related
Active Directory/LDAP :: Service Reposding Slow In One Application And Fast In Another Application
I have two applications(A,B) both are developed in .NET3.5 and used LDAP services.Application-A in one screen we are fetching users with role "project Leads" and it is taking 10 min time

Application-B in login screen we are checking user is authenticated or not and it is taking 20 sec

Both the applications are using the same service then way there is a time span problem. Please suggest me what can I do to improve performance of application A?

Posted: Jun 16, 2010 03:57 PM

View 3 Replies!   View Related
Debug Application - Relatively Slow
why is it that when i debug my application in chrome it is relatively slow between postbacks compared to internet explorer? when i use internet explorer, its lightning fast.

Posted: Apr 23rd, 2010, 07:22 AM

View 6 Replies!   View Related
Performance - Application Slow But CPU Is At 40% Max?
I have a strange situation on a production server. Connection for get queued but the CPU is only at 40%. Also the database runs fine at 30% CPU.

Some more history as requested in the comments:

In the peak hours the sites gets around 20,000 visitors an hour.
The site is an webforms application with a lot of AJAX/POSTs
The site uses a lot of User generated content
We measure the performance of the site with a testpage which does hit the database and the webservices used by the site. This page get served within a second on normal load. Whe define the application as slow when the request takes more than 4 seconds.
From the measurements we can see that the connectiontime is fast, but the processing time is large.
We can't pinpoint the slowresponse the a single request, the site runs fine during normal hours but gets slow during peak hours
We had a problem that the site was CPU bound (aka running at 100%), we fixed that
We also had problems with exceptions maken the appdomain restart, we fixed that do
During peak hours I take a look at the performance counters. We can see behaviour that we have 600 current connections with 500 queued connections.
At peak times the CPU is around 40% (which makes me the think that it is not CPU bound)
Physical memory is around 60% used
At peak times the DatabaseServer CPU is around 30% (which makes me think it is not Database bound)

My conclusion is that something else is stopping the server from handling the requests faster. Possible suspects:

Deadlocks (!syncblk only gives one lock)
Disk I/O (checked via sysinternals procesexplorer: 3.5 mB/s)
Garbage collection (10~15% during peaks)
Network I/O (connect time still low)

To find out what the proces is doing I created to minidumps.

I managed to create two MemoryDumps 20 seconds apart. This is the output of the first:

CPU utilization 6%
Worker Thread: Total: 95 Running: 72 Idle: 23 MaxLimit: 200 MinLimit: 100
Work Request in Queue: 1
Number of Timers: 64

and the output of the second:

CPU utilization 9%
Worker Thread: Total: 111 Running: 111 Idle: 0 MaxLimit: 200 MinLimit: 100
Work Request in Queue: 1589

Posted: Nov 19 10 at 16:30

View 3 Replies!   View Related
Web Forms :: Web Application Slow Loading?
I'm developing a web application on my Windows Vista laptop. The underlying database is MySQL.Everything was going just fine, until suddenly (really out of the blue) the application became painfully slow. Not just the webform I was working on at the time, but the entire application. I've tried running with a 'fresh' database, but that doesn't make a difference.In IE8 the progress indicator in the status bar fills up quickly to about 2/3 and then it "hangs" for a few minutes. And when it finally loads, it loads without the CSS styles. Very, very strange! In Firefox it won't load at all... it just hangs.Tracing is on in my application, but trace.axd won't load either!

The strange thing is that when this startedI wasn't doing anything special that might explain this problem.I've tried undoing my changes, but it doesn't help.Has anyone else here run into such a problem as well? Or better yet, does anyone have an idea as to what might be causing this sudden ultra slow loading?

Posted: Nov 28, 2009 04:44 PM

View 19 Replies!   View Related
Configuration :: C# Web Application Slow Once Published
My application runs quickly when debugging locally, but slows down to an almost unusable state once published. Oddly, the published version seems to be grabbing data very quickly from MSSQL - it's the part where I'm updating datatables and gridviews that is very slow. For example:


Posted: Jan 12, 2011 07:43 PM

View 8 Replies!   View Related
Web Forms :: Slow Web Application Startup
I know that when a .NET web application first starts, it will be slow on first access. For that reason, I created a 'keep alive' page in the application that is requested every 8 minutes or so by a scheduled process. I hoped that that would be sufficient to prevent the application from 'unloading' and thus suffer from this initial long startup time again and again.

I can see in my logs that the 'keep alive' page is indeed triggered every 8 minutes, 24 hours a day. But when I actively start working in the application after some time, eg. the following day, I still have to wait a while for it to start up.Once the first page is loaded, all is fine again.

Posted: Mar 24, 2011 12:17 PM

View 4 Replies!   View Related
Performance - Application Running Slow?
There's a web app I've been assigned to, which is running very slow. It is a site that sells products so it is database driven, however even pages that do not query the database are loading very slow. The pages use master pages, and the code is in VB.NETI checked with fiddler and the time it takes to load basic (non database driven) pages are about 5.5 seconds on average.

What are some tools that can help me determine the cause of the slow speeds, and any recommendations as to how to speed it up, or potential issues that could cause it?UpdateSo I messed around with the code piece by piece as I wasn't getting anywhere with these tools. As soon as I remove master pages, and I include the same code that's on the master pages in the .aspx page itself, the speed improves drastically (approximately 5 times faster load times).What might cause the master pages to cause load times to slow down so much?

Posted: Feb 22 at 0:07

View 4 Replies!   View Related
Web Forms :: Slow Execution Of Dot Net Application?
i have a dot net application.when i execute it it takes a much longer time to open has databae connected with it,intally it was not like the first page takes longeer time to open up

Posted: Sep 23, 2009 11:55 AM

View 2 Replies!   View Related
Functionality Is Working Fine But The Application Is Becoming Very Slow?
I have one ASP.NET Application (VS.NET 2005). In that i have one scenario where i have to display 500 records per page (Not less than that bcoz this is client requirement to display 500 records per page) in the Gridview. This functionality is working fine but the application is becoming very slow.Can anybody tell me the solution for increasing performance in this case ?

Posted: Sep 13, 2010 09:35 AM

View 2 Replies!   View Related
Web Forms :: When Run Application In Internet Explorer It Is Very Slow
when we run ASP.Net application in internet explorer it is very slow but when we restart IE then it will execute fast. Is there any reason behind it? it will work in Firefox very good but sometimes we need to restart IE for faster execution. We have suffer from this problem form last 3 to 5 month but recently i have join this forum so i think i may find solution by this way

Posted: Nov 02, 2009 06:24 AM

View 2 Replies!   View Related
Configuration :: Initial Web Application Load Is So Slow?
I have a simple web application that loads very slow the very first time after i deploy it.I am using ASP.NET 3.5 SP1 / VS 2008 / Linq / Web forms to load the default.aspx home page. It is a very light page with nothing too fancy.Now to debug this load issue, I logged all the events in the global file and got the following log text:

2010-04-10 11:58:38,083 - Application_Start
2010-04-10 11:58:38,111 - Application_BeginRequest
2010-04-10 11:58:38,117 - Application_AuthenticateRequest
2010-04-10 11:58:52,321 - Session_Start
2010-04-10 11:58:52,454 - Page_Load
2010-04-10 11:58:53,951 - End Page_load
2010-04-10 11:58:53,981 - Application_EndRequest

Now my question is, between the Application_AuthenticateRequest and Session_Start functions, there is generally around 10 - 15 seconds - which i believe seems to be the problem.The thing, I am unsure why this is slow between these two functions.I am not using any forms authentication.Also, I am not doing anything fancy in the global file besides setting a session variable.

Posted: Apr 11, 2010 01:05 AM

View 9 Replies!   View Related
Configuration :: Web Application Runs Slow On Hosting Server?
I have developed a web application in with c# with out using master page. I have developed this application in iframe.

The problem is that my application run smoothly but suddenly it stops and do some processing and it run again smoothly.

it stops any where on page load, on button click, on checkbox changed. i can not tell where it stops

it stops only whenpage post. i can see the processbar on browser's statusbarit stop for long time 40 to 60 seconds and after that i fire same event nowprocess complets within 2 to 5 seconds

Hosting server detail :

1. IIS 6.0

2. Window server 2003.

3. Sql server 2005.

Posted: Aug 16, 2010 06:29 AM

View 4 Replies!   View Related
Crystal Reports :: Too Slow In Application / How To Make It Fast
I have made an web application using VS 2008 to show crystal reports. I have used CrystalReportViewer control to show reports.

The table (sql server 2005 ) from which I have to fetch data has approximately 400000 records. I connect to it using OLEDB ( Microsoft OLEDB provider for sql server )

I have wrote the following code to achieve this :


Posted: Aug 11, 2010 05:59 AM

View 1 Replies!   View Related
AJAX :: TabContainer - Application Is Very Slow With The Double Postback
My problem is that Ithink I "Need" this control to post back because of the logic I am using to store the active tab index. Based on this active tab index, I am dynamically adding validation towhatever form the active tab index is. My problem is that the application is very slow with the double post back, "figure of speech", and I would love for the update panel to actually take control of this posting back issue. Here is my logic.


Posted: Nov 10, 2009 01:27 PM

View 1 Replies!   View Related
C# - WebMethod() Is Slow On Each Execution Compared To After Run It As A Windows Application
I have developed an application that interacts with IBM ClearQuest. The problem is that when I run everything locally, such as, run the webservice local and then ASP page local everything is at the speed I expect. When I post the webservice (precompiled) to the server and run the web page through the server, the call to the webmethod takes at least 10x the amount of time it should. I dont know why this is happening. I made a console application that has the function in question and execute it on the server and locally and they both return the same amounts of time (roughly) its just when I move to executing via the webmethod everything grinds to a snails pace. Any ideas? This happens every time not just on the first call.


Public Function RetrieveQueryResults(ByRef cqSession As ClearQuestOleServer.Session, _
ByVal sqlStmt As String) As List(Of SearchResultsSingleIssue)
Dim numCols As Integer, status As Integer, columnIdx As Integer
Dim numRows As Integer
Dim rowContents As String = ""
Dim colValue As New Object
Dim colLabel As New Object
Dim allitems As New List(Of SearchResultsSingleIssue)
Dim results As New SearchResultsSingleIssue
Dim cqResultSet As ClearQuestOleServer.OAdResultset
cqResultSet = cqSession.BuildSQLQuery(sqlStmt)
' Get the number of columns returned by the query.
numRows = 0
numCols = cqResultSet.GetNumberOfColumns
status = cqResultSet.MoveNext
' Collect query results.
Do While status = AD_SUCCESS
results = New SearchResultsSingleIssue
numRows = numRows + 1
For columnIdx = 1 To numCols
colLabel = cqResultSet.GetColumnLabel(columnIdx)
colValue = cqResultSet.GetColumnValue(columnIdx)
'Make sure that we dont pass along a null reference
If colValue = Nothing Then
colValue = ""
End If
Select Case colLabel
Case "ID"
results.IssueID = colValue
results.Headline = colValue
Case "NAME"
results.State = colValue
results.OEContact = colValue
results.Further_Description = colValue
results.Product_Name = colValue
results.Functional_Area = colValue
results.Subtopic = colValue
results.Found_In = colValue
results.Scheduled_For = colValue
results.Symptoms = colValue
results.Affected_System_Types = colValue
results.Issue_Type = colValue
results.Assigned_Developer = colValue
results.Assigned_Tester = colValue
results.Built_In = colValue
results.Tested_In = colValue
results.Notes_Log = colValue
results.Severity = colValue
results.Priority = colValue
End Select
Next columnIdx
' Add the query row result to the compiled list of all rows.
status = cqResultSet.MoveNext
Return allitems
End Function

Local Windows Application Method:

private void button2_Click(object sender, EventArgs e)
start = DateTime.Now.TimeOfDay.Seconds;

int numCols = 0;
int status = 0;
int columnIdx = 0;
int numRows = 0;
string rowContents = "";
string colValue;
string colLabel;
List<SearchResultsSingleIssue> allitems = new List<SearchResultsSingleIssue>();
SearchResultsSingleIssue results = new SearchResultsSingleIssue();
ClearQuestOleServer.OAdResultset cqResultSet = default(ClearQuestOleServer.OAdResultset);
cqResultSet = (ClearQuestOleServer.OAdResultset)ClearQuestSession.BuildSQLQuery(sqlStatement);
// Get the number of columns returned by the query.
numRows = 0;
numCols = cqResultSet.GetNumberOfColumns();
status = cqResultSet.MoveNext();
// Collect query results.
while (status == 1)
results = new SearchResultsSingleIssue();
numRows = numRows + 1;
for (columnIdx = 1; columnIdx <= numCols; columnIdx++)
colLabel = (string)cqResultSet.GetColumnLabel(columnIdx);
colValue = (string)cqResultSet.GetColumnValue(columnIdx);
//Make sure that we dont pass along a null reference
if (colValue == null)
colValue = "";
switch (colLabel)
case "ID":
results.IssueID = colValue;
case "HEADLINE":
results.Headline = colValue;
case "NAME":
results.State = colValue;
case "OE_CONTACT":
results.OEContact = colValue;
results.Further_Description = colValue;
results.Product_Name = colValue;
results.Functional_Area = colValue;
case "SUBTOPIC":
results.Subtopic = colValue;
results.Found_In = colValue;
results.Scheduled_For = colValue;
case "SYMPTOMS":
results.Symptoms = colValue;
results.Affected_System_Types = colValue;
case "ISSUE_TYPE":
results.Issue_Type = colValue;
results.Assigned_Developer = colValue;
case "TESTED_BY":
results.Assigned_Tester = colValue;
results.Built_In = colValue;
results.Tested_In = colValue;
case "NOTES_LOG":
results.Notes_Log = colValue;
results.Severity = colValue;
case "PRIORITY":
results.Priority = colValue;
// Add the query row result to the compiled list of all rows.
status = cqResultSet.MoveNext();
seconds = (DateTime.Now.TimeOfDay.Seconds - start);
label3.Text = seconds.ToString();

The code should execute in about...6 seconds.

Posted: Mar 11 at 21:56

View 1 Replies!   View Related
After Multiple User Login / Some Time C# Application Get Slow
In application all sql connection close properly, Also when user log out its connection close still sql process memory increase in RAM and after some time Application slow down.

Posted: Jul 2 10 at 6:44

View 3 Replies!   View Related
AJAX :: Implement Within An Existing Application / Slow Response?
I'm trying to implement AJAX within an existing application and it seems to be running slow.

I have 3 datallist that all have checkboxs. I have buttons that all users to check all checkbox for a specific datalist. I have an update panel around each datalist. When I check and uncheck it seems to be really slow. I also have 3 textboxes and 4
buttons within my update panel.

When I user uses this site it hides and shows different panels and that seems to be really slow when the users press a button. There is no database stuff happening when the slowness occurs.

Posted: Jan 31, 2011 07:29 PM

View 2 Replies!   View Related
Visual Studio :: Very Slow Performance / Developed A Web Application?
before some days i install vs 2010 beta 2 but i see it is very slow & performance is like a Trafic on 4 way in metro city i say blah blah blah how i cam developed a web application in vs 2010.

if i use 2010 i waste more time because performance is very-very slow.

line number is not show in any condition.

So anyone how can i improve our VS 2010 performance for work fastly

Posted: Nov 11, 2009 02:14 PM

View 4 Replies!   View Related
Visual Studio :: MSVS Is So Slow / Want To Run Application In Debug Mode?
When I want to run my application, in debug mode, it would takes more than 2 minutes till it start, If I use CTRL+F5 (no debug), it starts in less than 10 seconds.

I am using MSVS 2008 with SP1.

Posted: Aug 19, 2009 06:21 PM

View 3 Replies!   View Related
Iis7 - External References Slow Down Application (VS: Add Reference Dialog)?
I've noticed as my website gets bigger and bigger, the time my laptop takes to display my page is much longer then say a new projects with minimal references. I think there are two variables at play that affect ASP.NET warm-up time:

The quantity of external references The time it takes for a worker process to new() up each instance per worker process Additional time for the WCF objects as the ServiceHost may be in an external DLL First, are those the correct variables to take into account when considering ASP.NET startup time? Next, it appears that web.config may dispatch other objects for use with certain filetypes (*.svc, *.aspx, Windows Identity Foundation (WIF), etc. ). This too may cause delays in ASP.NET.

Last, my project is created as a "web project" not a "web site". Not sure if this has an impact. Is my theory full of holes, or is there something I can do to make development on a old laptop any better?

Posted: Aug 6 10 at 13:48

View 1 Replies!   View Related
Web Forms :: FileUpload And MaxRequestLength: Why Does Application Know So Fast And Form Know So Slow Of Exces
Let's say you set maxRequestLength to the max number (2097151) (units are KB) and use the following code for your OnClick event for your submit button:

int int fileSize = FileUpload1.PostedFile.ContentLength;

if (fileSize < 2000000)//units are bytes
Label1.Text="too big";
Label1.Text = "Upload success.";

Why when a huge file is attempted does it take a minute to get to the OnClick event on the server? Because if maxRequestLength were set to that value 2000, it would immediately choke if you tried to upload a 500MB file. What is going on here? What are the best practices for using the FileUpload control? Is there a better alternative way of uploading or checking for file size?

Posted: May 11, 2010 02:38 AM

View 5 Replies!   View Related
.net - LINQ To SQL Web Application Best Practices
In my experience building web applications, I've always used a n-tier approach. A DAL that gets data from the db and populates the objects, and BLL that gets objects from the DAL and performs any business logic required on them, and the website that gets it's display data from the BLL.I've recently started learning LINQ, and most of the examples show the queries occurring right from the Web Application code-behinds(it's possible that I've only seen overly simplified examples). In the n-tier architectures, this was always seen as a big no-no.I'm a bit unsure of how to architect a new Web Application.

Posted: May 7 10 at 0:53

View 2 Replies!   View Related
.net - Linq To Sql Datacontext For A Web Application
I'm trying to use linq to sql for my project (very short deadline), and I'm kind of in a bind. I don't know the best way to have a data context handy per request thread. I want something like a singleton class from which all my repository classes can access the current data context. However, singleton class is static and is not thread-safe and therefore not suitable for web apps. I want something that would create a data context at the beginning of the request and dispose of it along with the request

Posted: Mar 20 10 at 4:42

View 1 Replies!   View Related
.net - Will Linq To Sql Work In An .net 2.0 Web Application
Will linq to sql work in an 2.0 web applicationJust realized the server doesnt' support 3.5 (no control over it

Posted: Apr 9 10 at 15:43

View 3 Replies!   View Related
ADO.NET :: LINQ And Web Application Connection Strings
i want define connectionSreing in the web.config and then use it for DataContext ConnectionString. i do that : 1.i creat a class in App_Code:(MisaghDB is my database)

partial class MisaghDataContext
partial void OnCreated()
this.Connection.ConnectionString =
// or
public partial class MisaghDataContext
public MisaghDataContext() : base (ConfigurationManager.ConnectionStrings["MisaghDBConnectionString"].ConnectionString)

2. Add the connection string to my web.config file:

<add name="MisaghDBConnectionString" connectionString="Data Source=NAZLIN-HP;Initial Catalog=MisaghDB;Integrated Security=True"
providerName="System.Data.SqlClient" />

3. Right click on the DBML file design surface and chose properties. Select "none" for the Connection should i change DBML file designer.cs (Misagh.designer.cs) ? The code should I delete in this file(DBMLfile designer.cs)? this is a part of my DBMLfile designer.cs :

public partial class MisaghDataContext : System.Data.Linq.DataContext
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
public NorthwindDataContext() :
base(global::WindowsFormsApplication2.Properties.Settings.Default.NorthwindConnectionString, mappingSource)
public NorthwindDataContext(string connection) :
base(connection, mappingSource)
public NorthwindDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
public NorthwindDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
public NorthwindDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)

Posted: Dec 25, 2010 07:18 AM

View 4 Replies!   View Related
MVC :: Cannot Handle Exception In Linq Within Application
I have a rather complex queryin my opinion but I am a newbee in the LinQ area. The problem is that some results will return division by zero exception error. I really need to handle those because now the code breaks and the query ends. If there is 52 weeks and week 27 is a division by zero error line I still want to continue to render and display the rest of the weeks or the best would be just to render a 0 (zero) in that column that holds the error. All my code is below.


If you look at the line Average = rgroup.Sum(r => r.smsSales) / rgroup.Sum(r => r.smsOrders) it is a great sample. The sum can return zero and if it does an exception is thrown. I need it to handle a default value or in some way which I apparently dont know about can handle those exceptions within a linq query but still continue to run it.

Posted: Jul 14, 2009 10:08 AM

View 4 Replies!   View Related
ADO.NET :: Linq To SQL - Handle Concurrency In Application
I am trying to handle concurrency in my application. Basically ifuser Ahas a support ticket open whichcurrently has a status of 'Active' and user'B' opens the same ticket and closes it (changing itsstatus to closed), I would expect a confict execepton to be thown when user 'A' tries to close the support ticket. For some reason this is nothappening. I have checked that Update check is set to 'Always'in the dbml file. Here is an exerptof my code. // Update 'Active' lead to 'Close'


Posted: Aug 10, 2010 02:32 PM

View 2 Replies!   View Related
ADO.NET :: Create Large Application Linq To Sql?
i am curious to know which is generic way to create DAL which can be used to large application and small applications using ?

1) What can i use to create large application Linq to Sql OR Entity Framework Or Any others ?

Posted: Dec 26, 2010 06:32 AM

View 2 Replies!   View Related
MVC :: NullReferenceException Was Unhandled By Usercode In Application Using Linq To Sql
I am getting an exception like"NullReferenceException was unhandled by usercode-Object reference not set to an instance of an object." in (IEnumerable)Viewdata.Model.

<% foreach (EmployeeMaster m in (IEnumerable)ViewData.Model)

Posted: Feb 16, 2010 11:28 AM

View 3 Replies!   View Related
DataSource Controls :: LINQ To SQL For Web Or Desktop Application (WCF)
is it good for desktop application (WCF) or web application.I am little confuse about LINQ functionalities i have read some articles which are discourage LINQ (due to poor performance) for web applica

Posted: Apr 01, 2010 09:05 PM

View 3 Replies!   View Related
Visual Studio :: How Many Layers In LINQ Application
I have question about N-tier architecture. everyone about 3-Layer architecture these are:

1). UI Layer,

2). Business Layer,

3). Data Access Layer.

i already have worked on this.

Then i heard about LINQ to sql. how many layer an web application should contain.

As my knowledge. if i use LINQ to slq then i have to worked only 2-Layer:

- Data Acess/Business Layer: which contains only *.dbml files which is my database and

- UI Layer:which contains *.aspx files.

Posted: Apr 01, 2010 03:16 PM

View 3 Replies!   View Related
Data Access Application Block VS LINQ To SQL For ASP.NET Apps?
Have investigated and tested Data Access Application block from Microsoft Enterprise Library 4.1, which has impressed with best practises and fewer lines of code to interact with Database.

Cons: Requires us to supply / write SQL statements


Have watched an hour video here and impressed with in-built support for Joins/Stored Procedures/Transactions.It is feasible to express and perform Joins between Tables using C# language. Behind the scenes the Query Engine generates actual SQL Join statements.

May still consider Data Access Application block from Enterprise Library where a single line of code can perform CRUD(create,Retrieve, Update, Delte) oeprations. still it requiers to supply complex sql statements here.When LINQ to SQL:- learning curve for new syntax and indeed it is hiding complex queries job from us.Which way to go?? Data Access Application block OR LINQ to SQL??

Posted: Apr 30, 2009 04:22 PM

View 1 Replies!   View Related
ADO.NET :: How To Improve The Application Performance While Writing LINQ Queries
how to improve the application performance while writing LINQ Queries ?Like the optimization techniques.

Posted: Dec 17, 2010 04:09 AM

View 2 Replies!   View Related
DataSource Controls :: LINQ Vs NHibernate For New Enterprise Application?
I need to make a chose between LINQ and NHibernate for a new enterprise application. I have used a little bit of NHibernate. These are the questions I have :

1.Does LINQ support multiple databases seamlessly?

2. Are there any performance issues with LINQ ?

3. IsLINQ mature enough to be implemented anenterprise application ?

4. When I use Lazy-loading with NHibernate I had trouble figuring out when to close the NHibernate session, I mean when I had a GridView which has columns that are properties resolved from a relationship and I close the session I used to get a lazy-loading exception, How can I handle that with LINQ ?

Posted: Apr 22, 2008 05:16 PM

View 1 Replies!   View Related
Visual Studio :: How Many Layer-Tier In LINQ To SQL .net Web Application
I have question about N-tier architecture. everyone about 3-Layer architecture these are:1). UI Layer, 2). Business Layer, 3). Data Access Layer.i already have worked on this.Then i heard about LINQ to sql. please tell me how many layer an web application should contain.As my knowledge. if i use LINQ to slq then i have to worked only 2-Laye

Posted: Apr 01, 2010 03:11 PM

View 9 Replies!   View Related
DataSource Controls :: Way To Develop Application With Linq And Used Stored Proc
I am Developing A Application . I want to develop this Application with Linq and used Stored proc in linq Plz give me Some suggestion How we used And If You Have Some Related Topic

Posted: Feb 05, 2010 04:52 AM

View 1 Replies!   View Related
DataSource Controls :: LINQ Performance Application Performance Is Not Up To Par?
I am not sure if this is the right forum. I can not find a forum for LINQ.

I am working on an application using LINQ. Application performance is not up to par and my testsshow that it isLINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.

Posted: Apr 29, 2010 12:09 AM

View 1 Replies!   View Related
Copyright 2005-08, All rights reserved