{"id":2853,"date":"2011-07-15T07:36:17","date_gmt":"2011-07-15T07:36:17","guid":{"rendered":"http:\/\/jellywp.com\/theme\/entron\/demo5\/?p=2853"},"modified":"2011-07-15T07:36:17","modified_gmt":"2011-07-15T07:36:17","slug":"linq-to-sharepoint-examples","status":"publish","type":"post","link":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/linq-to-sharepoint-examples\/","title":{"rendered":"LinQ to SharePoint examples"},"content":{"rendered":"

Namespaces to refer in Visual studio for using LinQ<\/strong>
\nusing System.Linq;
\nusing Microsoft.SharePoint.Linq;
\nusing System.Collections.Generic;<\/p>\n

Generate Entity classes using SPMetal<\/strong>
\nRun the following command to generate it
\nspmetal \/web:http:\/\/ \/code:<\/p>\n

Creating a Join between two list UserAccounts and Invoices<\/strong>
\nList UserAccounts have Account, Name
\nList Invoices have Account, Amount, Paid<\/p>\n

\/\/First refer the Datacontext class<\/span>
\nXDataContext a = new XDataContext(SPContext.Current.Web.Url);<\/p>\n

\/\/Refere the Lists and create entityLists out of them<\/span><\/p>\n

EntityList Invoices = a.GetList(“Invoices”) ;
\nEntityList UserAccounts = a.GetList(“UserAccounts”);<\/p>\n

\/\/need to do a join from the two lists and bring them together.<\/span>
\n\/\/use the ToList() on the list in the from to avoid getting errors due to inefficient CAML queries. with this method it retrives data from the list instantaniously.<\/span><\/p>\n

var query=
\n(from u in UserAccounts.ToList()
\njoin i in Invoices on u.Account equals i.Account
\nwhere int.Parse(u.Account.ToString()) > 1001 && int.Parse(u.Title.ToString()) < 10010
\nselect new { u.Name, u.Account, i.Amount, i.Paid }) ;<\/p>\n

\/\/make this as the datasource.<\/span>GridView1.DataSource = query;
\nGridView1.DataBind();<\/p>\n

Inserting in Lists using LinQ <\/strong><\/p>\n

XDataContext a = new XDataContext(SPContext.Current.Web.Url);<\/p>\n

EntityList Invoices = a.GetList(“Invoices”);<\/p>\n

int count = 0;
\n\/\/get the count of the records<\/span>
\ncount =
\n(from x in Invoices
\nselect x).Count();<\/p>\n

List ic = new List();<\/p>\n

if (count == 0)
\n{
\n\/\/insert 5K records<\/span>
\nfor (int i = 0; i < 300; i++)
\n{
\n\/\/create records and store them in a system.collection.generic.list collection<\/span>
\nInvoicesItem inv = new InvoicesItem() { Account = “100” + i.ToString(), Amount = 100 + i, Paid = check(i) };
\nic.Add(inv);
\n}<\/p>\n

\/\/insert all of them in shot<\/span>
\nInvoices.InsertAllOnSubmit(ic);
\na.SubmitChanges();
\n}<\/p>\n

\/\/here is the check function that is being used<\/span>
\nprivate Boolean check(int i)<\/p>\n

{
\nif (i % 2 == 0)
\nreturn false;
\nelse
\nreturn true;
\n}<\/p>\n","protected":false},"excerpt":{"rendered":"

Namespaces to refer in Visual studio for using LinQ using System.Linq; using Microsoft.SharePoint.Linq; using System.Collections.Generic; Generate Entity classes using SPMetal Run the following command to generate it spmetal \/web:http:\/\/ \/code: Creating a Join between two list UserAccounts and Invoices List UserAccounts have Account, Name List Invoices have Account, Amount, Paid \/\/First refer the Datacontext class […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/posts\/2853"}],"collection":[{"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/comments?post=2853"}],"version-history":[{"count":0,"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/posts\/2853\/revisions"}],"wp:attachment":[{"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/media?parent=2853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/categories?post=2853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teamwp.mydevfactory.com\/abhisek-saha\/aqltech\/wp-json\/wp\/v2\/tags?post=2853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}