LINQtoSharePoint Forum Rss Feed

New Post: SPMetal: Exporting all Lists

senfo — Tue, 29 Sep 2009 16:42:48 GMT

I would like to generate an entity class for each lists in my SharePoint site. The documentation is written as follows:

-list:<list> Name of the list to export (* = all lists)

My understanding is that I would use the * to export all lists like the following:

spmetal -url:foo.com -list:*

Doing so, however, causes the following error: Failed to generate SPML. Cannot load the list definition for *

What am I doing wrong?

New Post: Extract SharePoint Contents ?

cooldude_82 — Wed, 16 Sep 2009 22:01:13 GMT

It seems that for some reason selecting a list that consist of two words (space between them) like "Shared Documents" or "Team Discussions" will not work !!

classes are not generated for these list ? any help ?

Thanks

New Post: Extract SharePoint Contents ?

cooldude_82 — Wed, 16 Sep 2009 21:39:08 GMT

I guess I figured it out, selecting all lists in the wizard will not generated classes ..but If I select only one list like (Tasks) , I will get the classes generated ..

this framework is really great.

New Post: Extract SharePoint Contents ?

cooldude_82 — Wed, 16 Sep 2009 19:59:26 GMT

Hi,

I am just wondering if it is possible to use this library to extract Tasks, Announcements, Team Discussions ...etc from SharePoint ?

I noticed that the framework will generate C# classes for the lists that I create myself on SharePoint ..but it will not generate classes for Tasks or Calendar for example .

if this is possible how to query Tasks ?

Thanks

New Post: FileNotFoundException (BdsSoft.SharePoint.Linq)

matrich — Mon, 24 Aug 2009 10:01:31 GMT

Hi all,

It seems I have gotten a work around for the error I was getting above. In my published website, I added the BdsSoft.SharePoint.Linq.dll file to the Bin folder and everything worked again. Hope this helps someone else who might get the same problem.

On another note, is this project still live or dead? I emailed Bart and also posted here the above problem. And in a week or so, i got no response even to acknowledge. Anywayz, thanks for the great project THO I was going to go back to CAML.

Thanks,
Matrich

New Post: FileNotFoundException (BdsSoft.SharePoint.Linq)

matrich — Wed, 19 Aug 2009 04:57:10 GMT

Hi,

Thanks for this helpful project. I am building an ASP.NET website using your project. In my solution, I have a Class library where all the logic is done which includes the *.spml file and a website which uses the class library as a reference. When I run the solution in VS 2008, everything works well BUT when I move the solution to server, I get an error. When I checked the Event Viewer on the server, below is the exception which isn't handled:

Exception information:
Exception type: FileNotFoundException
Exception message: Could not load file or assembly 'BdsSoft.SharePoint.Linq, Version=0.2.4.0, Culture=neutral, PublicKeyToken=c9246ff4557ee8a2' or one of its dependencies. The system cannot find the file specified.

I will be very grateful for your help.

Thanks,

Matrich

New Post: use in InfoPath or webservice

suzbeau — Fri, 07 Aug 2009 21:36:16 GMT

This is a cool tool and it works great in a console app, but I would love to use it to parse data going into an InfoPath form (on browser). Possible?

New Post: Cannot connect to a MOSS 2007 Publishing Site

combiths — Wed, 29 Jul 2009 16:21:27 GMT

Does this product support MOSS 2007 Enterprise publishing sites? I can connect to a blank site in MOSS but not a publishing site. Any help?

New Post: SPML suddenly unfunctional

joewood72 — Mon, 22 Jun 2009 19:30:05 GMT

From looking at the code, it looks like the referenced list needs to be in the same SP context - i.e. in the same SPML file.

http://code.google.com/p/uniframework/source/browse/trunk/sources/Uniframework.SharePoint.Linq.EntityGenerator/EntityGenerator.cs

I added all my lists under the <Lists> element in the SPML file and this seemed to fix this problem.

New Post: Failed to generate spml. Cannot load the list definition for docs

pandiyaa — Fri, 19 Jun 2009 21:13:58 GMT

I have the same issue... does any =one confirm this tool will not work with Doc library??

Thanks

New Post: Is this projet still alive ?

Lambros — Fri, 12 Jun 2009 16:53:54 GMT

Yea it looks like its dead for a long time.

I will start using it so I might do changes and upload them as patches if I am able

New Post: Is this projet still alive ?

manitra — Fri, 05 Jun 2009 16:51:34 GMT

Hi,

It looks like there are no changes on this project since more than 18 months, is it still alive ?

Manitra.

New Post: Querys with JOIN

bdesmet — Mon, 01 Jun 2009 09:36:48 GMT

Hi Wagner,

LINQ to SharePoint doesn't support joins, as the underyling query language (CAML) hasn't built-in support for it. Implementing joins would require the provider to have to download big chunks of data to the client in order to execute the join code there. In general that's not a good thing as the remote execution properties of the LINQ query become superfluous. Rather, to make developers aware of this, the provider doesn't try to be smart and requires local joins to be executed explicitly using LINQ to Object. Recall that you can turn execution from remote into local by calling the AsEnumerable() method. For example, you could have two queries to select the sources to be joined, each of which you call AsEnumerable on, and then use with LINQ join syntax to have the join execute locally:

from x in (from y in src.Z where ... select y).AsEnumerable()
join a in (from b in src.C where ... select b).AsEnumerable() on x.K equals a.L
...
select ...

Hope this helps,
-Bart

New Post: Querys with JOIN

waamorim — Sun, 31 May 2009 17:50:22 GMT

Hello!

I have "LINQ To SharePoint v0.2.4.0" with VS 2008 and WSS 3.0.

I can't 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

New Post: SharePointDataSource

sanchoponsa — Tue, 05 May 2009 10:30:47 GMT

ok guys...

i just tried a bit around and i got it (maybe the example is from an older version of LINQ to SharePoint):

it should be like this:
var t = new SharePointList<T>(new SharePointDataContext(new Uri("http://<insert servername here>")));

so long
sancho

New Post: SharePointDataSource

sanchoponsa — Tue, 05 May 2009 10:24:33 GMT

Hi there,

I hope somebody can help me although i guess this project is dead anyway...

In the examples of "how to use LINQ to SharePoint", it is mentioned that I have to use a type named "SharePointDataSource" to write queries against the SharePoint list. Anyhow, I can't find this type in the BdsSoft.SharePoint.Linq.dll ... Can anyone give me a hint?

so long,
sancho

New Post: Project still alive?

aggieben — Tue, 07 Apr 2009 01:54:30 GMT

Still nothing? Is anyone actively maintaining LINQtoSharePoint?

New Post: SPML suddenly unfunctional

luciano_arias — Mon, 16 Mar 2009 17:56:26 GMT

Hi there,

I was having the same issue... Based on what apauluhn was getting...it looks like this solution does not like the lookup / referenced columns...

New Post: SPMetal - List Instance dependency?

austegard — Tue, 03 Feb 2009 18:08:09 GMT

Does it make sense for the SPMetal generated classes to be tied to a given instance of a list? Not entirely sure that this is the case, but the ID attribute of the List class certainly seems to suggest that.

Doesn't the list ID change every time you instantiate the list template, and thus how would you use this in a scenario where you develop on one box and deploy a solution to another, thereby reinstantiating your lists?

New Post: How to connect to site using the object model?

michaelerasmus — Wed, 29 Oct 2008 09:43:18 GMT

Sorry if i missed something and this is a stupid question. In all the example code i've seen uses a Uri to connect to the site. I saw that the Sharepoint constructor that accepts a Uri object uses the WebServicesSharePointDataProvider. So I assume that's the way to connect to the site using the SharePoint webservices. The other construtor takes a ISharepointDataProvider, but the only
defined in the BdsSoft.SharePoint.Linq.Providers namespace is the WebServicesSharePointDataProvider. So how do you connect using the object model?

Thanks
Michael