Linq Where Clause ‘AND’ ‘OR’
just wanna know how to use Linq if i have this code.
linq-to-sql
Linq count and sum in join
I want to get rows with the count column and sum column like in the SQL command ... count(column1.table1) as countname, sum(column2.table1) as sumname ..., but I don’t know the right way to write it in Linq, for the example:
add nested group by query Linq to property model class ASP.NET
I have struggle with adding the grouped data table with linq query to model property.
Get average to closest whole number
I have two tables
Will using LINQ to SQL help prevent SQL injection
I’m setting up a public site and the first thing on my mind is SQL injection. I have some text fields I’m saving and am using linq to update/write to the database. Am I safe using linq?
How to make LINQ execute a (SQL) LIKE range search
I am in big need of help, i have been trying to do this for some time now.
LINQ to SQL Where Clause Optional Criteria
I am working with a LINQ to SQL query and have run into an issue where I have 4 optional fields to filter the data result on. By optional, I mean has the choice to enter a value or not. Specifically, a few text boxes that could have a value or have an empty string and a few drop down lists that could have had a value selected or maybe not…
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. I’ve been using the Server Explorer and dbml designer in VS2008 to create the dbml and object relationships. It seems a little unclear to me if the dbml would be considered the DAL layer, if the website should call methods within a BLL, which then would do the LINQ queries, etc.
What are some general architecture best practices, or approaches to creating a Web Application solution using LINQ to SQL?
Linq to Sql – Set connection string dynamically based on environment variable
I need to set my connection string for Linq to Sql based on an environment variable. I have a function which will return the connection string from the web.config based on the environment variable, but how do I get Linq to always use this “dynamically created” connection string (preferably without having to specify it every time)?
Returning a single value with Linq to SQL
I’m learning Linq to SQL and I’m having trouble grasping it. I’m trying to simply return a single (boolean) value in C# with a Linq query.