Joining two tables using LINQ
I have two tables:
linq-to-sql
Encrypt column data with LINQ
I was wondering if there is easy solution to this or I’m stuck with following:
ASP.Net User activity tracking in database
This is about a simple yet efficient activity logging framework that I want to integrate with my existing ASP.Net based web-app (I’ve a LINQ-to-SQL based SQL DB as backend). I’m using something like a service-architecture to perform DB operations – that is invoke relevant LINQ operations. I’ve a service class for almost every entity (i.e. DB table) and it handles the CRUD operations.
Purpose of EF 6.x DbContext Generator option when adding a new data item in Visual Studio
I have a web app that I built using LINQ to SQL and I’m looking to upgrade it to LINQ to Entity Framework. I’ve looked at some tutorials and what I’ve learned is that basically in the database-first scenario, you create an ADO.NET Entity Data Model. And from there, you select which tables to include in the model (very similar to LINQ to SQL).
Most efficient way to update with LINQ to SQL
Can I update my employee record as given in the function below or do I have to make a query of the employee collection first and then update the data?
Should I use Linq To SQL directly in code behind or use some other approach?
We are developing a project in ASP.NET/C# which is a not a very large project but a sizeable one. Currently we have developed few pages. I am talking from point of view of a single page right now.The approach is followed for every pages that has been developed so far. In the code behind of … Read more
LinqToSql static DataContext in a web application
In a web application that I have run across, I found the following code to deal with the DataContext when dealing with LinqToSQL
Are Linq to sql objects serializable for session state?
Without going into whether this is a good or bad idea:
Cannot insert explicit value for identity column in table ‘ClientDetails’ when IDENTITY_INSERT is set to OFF
I get this exception thrown whenever I try and submit data through a form to this database :-
Using a DataContext static variable
I have recently inherited an ASP.Net app using Linq2SQL. Currently, it has its DataContext objects declared as static in every page, and I create them the first time I find they are null (singleton, sort of).