Tom's MSDN Belux Corner

Hi Tom,

Thanks for linking to the LINQ to SharePoint project. I'm happy to announce an interim release is coming up later this week, which will cover a first set of VS 2008 IDE integration.

Cheers,

-Bart

Hello My friend!

I have "LINQ To SharePoint v0.2.4.0" (http://linqtosharepoint.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=8713) with VS 2008 and WSS 3.0.

I cant use function JOIN in my queries, why?

Example:

private System.Net.NetworkCredential CredenciaisU = new System.Net.NetworkCredential("hcdadmin", "#cd@dm!n09");

public DataSet GetSituacaoCadastral(String VRegional, String VDistri, String VFunc) {

OSharePointDataContext dsSC = new OSharePointDataContext();

dsSC.Credentials = CredenciaisU;

DataSet ds = new DataSet();

var OUsuarios = dsSC.Usuarios;

var ODistribuidores = dsSC.Distribuidores;

var querySC = from u in OUsers //from d in ODistribuidores

//where u.Cargo == Funcao && u.Distribuidor == Distribuidor// && u.Distribuidor == d.Distribuidor

join d in ODistri on u.Distri equals d.Distri

where u.Cargo == VFunc && d.Distri == VDistri && d.Regional == VRegional

select new {Name = u.FullName, Distri = u.Distri};

DataTable dtSC = new DataTable("SituationC");

//

dtSC.Columns.Add("FullName");

dtSC.Columns.Add("Distri");

//

DataRow row;

foreach (var nSC in querySC) {

//

row = dtSC.NewRow();

row["FullName"] = nSC.Name;

row["Distri"] = nSC.Distri;

dtSC.Rows.Add();

}

ds.Tables.Add(dtSC);

return ds;

}

Thanks!!!

Wagner Amorim

wa.amorim@hotmail.com