-
as seen on C# Corner
- Search for 'C# Corner'
This article demonstrates how to use LINQ on DataTable, XML Data using LINQ to XML and SQL server data base using LINQ to SQL Classes.
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am running a query using Linq2SQL that comes down to following query:
DateTime? expiration = GetExpirationDate();
IQueryable<Persons> persons = GetPersons();
IQueryable<Items> subquery = from i in db.Items
where i.ExpirationDate >= expiration
…
>>> More
-
as seen on ASP.net Weblogs
- Search for 'ASP.net Weblogs'
The way data can be retrieved in .NET. LINQ provides a uniform way to retrieve data from any object that implements the IEnumerable<T> interface. With LINQ, arrays, collections, relational data, and XML are all potential data sources. Why LINQ?With LINQ, you can use the same syntax to retrieve…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a Logic layer that references Silverlight's System.Xml.Linq dll and a GUI that is in WPF (hence using the non-Silverlight System.Xml.Linq dll). When I attempt to pass an XElement from GUI project to a method in the Logic project, I am getting (basically) "XElement is not of type XElement" errors…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi, I am using SQL Server 2005 in a project. I have to decide about datalayer. I would like to use LINQ in my project. I saw SubSonic 3 supporting LINQ and I also have option for LINQ to SQL, because i can have typed lists from LINQ to SQL.
I am wondering what is different between LINQ to SQL and…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
HI COMUNITY!!!!
I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error:
specified store provider cannot be found in the configuration…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database..
In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules :
The comparison is a "Contains" mode, not strict compare : easy as…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this:
var temp = from p in myEntities.ClassA.Include("ClassB")
where ...
select p;
You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
HI COMUNITY!!!!
I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error:
specified store provider cannot be found in the configuration…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi There,
I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags.
I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often.
I currently…
>>> More
