Linked Questions

I found the equivalent of the following in the software I work on: using(var dbContext = Startup.Services.BuildServiceProvider().GetService<ApplicationDbContext>()) { while(true) { ...

What's the best practice in terms of setting up my DataContext for easy access in my extended LinqToSql classes? For example, I have a "User" entity in my dbml and I want to add methods to that ...

Traditionally, when we use SQL string to done some work, we have to close the sql connection before the page being closed, I was wondering if I use Linq to do the data operations do I still need to ...

When showing my main window, I make a list of objects from linq-to-sql: using (var context = new Data.TVShowDataContext()) { Shows = new ObservableCollection<Data.Show>(context.Shows); ...

I have several classes based on System.Entity.Data.DbContext. They get used several times a request in disparate ends of the web application - is it expensive to instantiate them? I was caching a ...

I belived it was not possible to get sql connection leaks when using LINQ, but perfmon tracing of NumberOfReclaimedConnections shows a high number and on high load we sometimes get exceptions like "...

I've been getting lots of connection pool timeouts in my ASP.NET MVC project. I've been reading that even though Linq-to-SQL should be disposing for me it doesn't always work and also that not ...

I am making sure to fully understand this following code: static void Main(string[] args) { var person = new Person {FirstName = "Nadege", LastName = "Deroussen", BirthDate = DateTime.Now}; ...

I encapsulate my linq to sql calls in a repository class which is instantiated in the constructor of my overloaded controller. The constructor of my repository class creates the data context so that ...

In Our project I have used LINQ to SQL for every kind of database interaction. Now from what I know , When I create and use DataContext object : it opens the connection , crates a transaction , ...

I am using "Single data context per atomic operation" approach while using Linq to Sql in an ASP.NET MVC application. So far, I have been using a singleton datacontext, which I learnt has many issues,...

UPDATE As Mathias notes below, this exact problem has been reported and resolved here: ASP.NET-MVC (IIS6) Error on high traffic: Specified cast is not valid ORIGINAL POST This may be too specific a ...

I'm working on a ASP.Net webform app and I am wondering how long I should keep my data context around. Currently I create a context on each page load, and that context is used in every db access for ...

I'm having some problems with DataContexts using linq to sql for an asp.net c# web application. I first had problems with exceptions being thrown as I didn't dispose of the DataContext, same errors as ...

There are two tables: Account (id) and BranchId(Id,Name,AccountId) and I have this code in pageload protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (...