Language Integrated Query, LINQ, is a .NET Framework component used for native data querying

learn more… | top users | synonyms

2
votes
5answers
4k views

Quick and effective way to do an inner join using LINQ to Sharepoint on 2 tables

I can't seem to find a guide which explains how to do an inner join on lookup fields using LINQ. Most of the guides require converting the EntityLists to custom objects so you can join on non lookup ...
0
votes
1answer
2k views

Linq: How to use EntityLists to do a join on a lookup field?

I have 2 lists, one list contains a lookup to another. I have used SPMetal to generate entity.cs based on this article: http://www.eggheadcafe.com/tutorials/aspnet/b0c1cd0d-fe82-444e-a16e-...
0
votes
2answers
808 views

LINQ to Sharepoint InsertOnSubmit Question

For example I have a list called Product and it has 3 columns, ProductName (which is the Title), ProductPrice and ProductType. ProductName is a string ProductPrice is a currency (double) ...
2
votes
4answers
579 views

why doesn't SPMetal generate Publishing Schedule columns?

Happy 2011 experts, I have a sharepoint 2010 publishing site that I use SPMetal to generate classes to. The problem is some fields do not get generated like: PublishingStartDate and ...
1
vote
2answers
1k views

LINQ to SharePoint and localized list names

I'm trying to use Linq to SharePoint to save a new record in my list. I provided my own List definition for which I have 2 resource files that are giving the good list names (French and English). ...
0
votes
1answer
260 views

Can I use .NET 3.5 language features in Sharepoint 2007

Can I use .NET 3.5 language features in SharePoint 2007. I want to use LINQ on an in memory collection (SPListItemCollection for example). I want to write extension methods. Can I do this with ...
5
votes
2answers
688 views

Get CAML from LINQ to SharePoint

Is there an equilivant to GetCommand in LINQ to SharePoint? I know about ctx.Log, but I'm looking for something to retrieve the CAML from a LINQ statement without executing it.
1
vote
1answer
726 views

Using SPMetal to read data from sharepoint 2010

I've just started to look at using spmetal with SP 2010 to read data from document libraries: http://msdn.microsoft.com/en-us/library/ee538255.aspx I'm curious as to how I can ensure that I only ...
0
votes
1answer
1k views

How can I update the record in sharepoint 2010 using linq?

I am unable to update the record in SharePoint 2010 using new linq feature. follwoing in my code please review it. AbsentTrackingSystemEntitiesDataContext ctx = new ...
5
votes
1answer
408 views

SPMetal and automated build approch

When using SPMetal to generate entity classes, these classes are used in LINQ to SharePoint queries. We have a project with content type and list definitions and one project with business logic which ...
1
vote
1answer
1k views

Sharepoint 2010: Full text plus faceted search over an External Content List using Search Services (or possibly FAST)

I have an External List over a products table in our database. I want to be able to build a search form over it via a full text search; in addition to being able to filter down on properties on my ...
1
vote
1answer
1k views

how to linq query spfield to spuser

Here is my code. SPUser approver = mySite.EnsureUser(approverId); var selectedItems = listItems.Cast<SPListItem>().Where(p => p.Fields["WF_Approver"] == approver); my list items field "...
3
votes
3answers
8k views

Using LINQ to select SPListItems and load a SPGridView

Is there a way to run this LINQ statement var items = from SPListItem li in listSettings.Items where li["WebID"].ToString() == SPContext.Current.Web.ID.ToString() orderby li["Title"]....
2
votes
2answers
684 views

Editing web.config file from a feature using linq

I have custom web.config functionality that uses Linq to merge elements into a web.config based on a template file. I would like to use this in a feature so I can get it to merge all web.configs in a ...