LINQ to SharePoint

Commented Issue: Exception at comparison of values of type System.Nullable with null

jhanford — Tue, 05 Aug 2008 17:22:19 GMT

Hi, i wish to construct such expression:

from n in ctx.News
where n.Validity != null
|| n.Validity >= DateTime.UtcNow
select n;

Here Validity has type System.Nullable<System.DateTime>.
However i have exception.

Thanks!
Comments: ** Comment from web user: jhanford **

I think your problem may actually lie in the fact that you're using an OR (||) operator instead of an AND (&&) operator with the null check

from n in ctx.News
where n.Validity != null
&& n.Validity >= DateTime.UtcNow
select n;

--Jason

Created Issue: Exception at comparison of values of type System.Nullable with null

grenixo — Tue, 05 Aug 2008 08:25:10 GMT

New Post: Alias for choices enum

grenixo — Mon, 04 Aug 2008 07:39:02 GMT

Greetings As it would be good, if it was possible to specify a pseudonym for enum choice.
I work with not English names, therefore there is a problem similar to this Incomplete encoding of FieldRef names

Thanks

Patch Uploaded: #1533

rkierner — Thu, 17 Jul 2008 13:08:47 GMT

rkierner has uploaded a patch.

Description:
If you have a list that has a lookup field to a list that has a lookup field, the second list is not included in output file from SPMetal. This patch creates a recursive method to make sure that the tree is fully included. I created the method "GetRelatedLists" on line 182 of EntityGenerator.cs in the BdsSoft.SharePoint.Linq.Tools.EntityGenerator project. So to apply the patch, I guess just replace that file and recompile

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

GR — Thu, 03 Jul 2008 20:49:36 GMT

Hi,
This is a great tool and I'm really excited about using it. I think it's just what SharePoint needs to get the 'messy' data into something to code against.

When I run spmetal against a document library I get the the following error:

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

The library is a document library. (Perhaps it does not support doc libs?)

Does anyone know what this error is caused by?
Thanks

NEW POST: Project still alive?

lurko — Wed, 14 May 2008 11:21:43 GMT

Marzel wrote:
Is the project still alive? There are no checkins this year. Is there a roadmap for the beta version?

I do not know the status of this project, but if you are interested in using LINQ for SharePoint development, there is a new solution on the horizon. It's a solution called LINQ4SP, you can find more info here: http://www.sharepointblogs.com/aghy/archive/2008/05/08/announcing-linq4sp.aspx

NEW POST: Project still alive?

lurko — Wed, 14 May 2008 11:20:35 GMT

Hi Marzel,

I do not know the status of this project, but if you are interested in using LINQ for SharePoint development, there is a new solution on the horizon. It's a solution called LINQ4SP, you can find more info here: http://www.sharepointblogs.com/aghy/archive/2008/05/08/announcing-linq4sp.aspx

NEW POST: Project still alive?

Marzel — Fri, 25 Apr 2008 09:10:36 GMT

Is the project still alive? There are no checkins this year. Is there a roadmap for the beta version?

NEW POST: Search Documents

kyleroche — Tue, 22 Apr 2008 16:36:37 GMT

Can you use this to query documents using the full text search?

Thanks!

NEW POST: Problem with Calculated field in SPMetal

jki — Mon, 21 Apr 2008 09:58:33 GMT

Hi,

I'm using SPMetal to general code for one of our big sharepoint lists that has several lookups into other lists.
One of those other lists has 2 calculated fields to concat "Last Name" and "First Name" fields into a "Full Name" field using the formula:

=[Last Name]&","&" "&[First Name]

SPMetal seems to throw an error when it encounters those fields:

Invalid Lookup field list reference encountered: list {a1cc3412-9fb5-4387-98ea-5e4cc93ea259} referred to by field Main_x0020_Contact is unknown in the SharePoint context.

The list the error references does exist.

Can anyone advise if SPMetal should be able to cope with these calculated fields?

Thanks

JKI

NEW POST: SPML suddenly unfunctional

velvet — Fri, 04 Apr 2008 13:04:36 GMT

Hi,

I have the same problem.
The error I'm getting is:

Invalid Lookup field list reference encountered: list Docs referred to by field
_CheckinComment is unknown in the SharePoint context.

Thanx

NEW POST: Using the same entity class for multiple lists

csgero — Tue, 01 Apr 2008 15:18:41 GMT

If I see this correctly, currently an entity class is bound to a single SharePoint list instance. I think it would be useful if you could use the same entity class for multiple list instances, as it is quite common to have multiple lists having the same schema, but currently there is no way to write code that could handle all these lists the same.
For example I could imagine an overload for SharePointDataContext.GetList<T>() that would also take the name of the list:
SharePointDataContext.GetList<T>(string listName)
What do you think of this?

COMMENTED ISSUE: SpMetal crash for choice fields without FillInChoice attribute

RajKrishnan — Mon, 31 Mar 2008 15:08:59 GMT

Unhandled Exception: System.NullReferenceException: Object reference not set to
an instance of an object.
at BdsSoft.SharePoint.Linq.Tools.SpMetal.Program.GetType(XmlNode c, Boolean&
additional) in C:\LinqToSharePoint\LinqToSharePoint\SpMetal\Program.cs:line 681
at BdsSoft.SharePoint.Linq.Tools.SpMetal.Program.Main(String[] args) in C:\Li
nqToSharePoint\LinqToSharePoint\SpMetal\Program.cs:line 438
Comments: ** Comment from web user: RajKrishnan **

I still get this error whenever I access a list field with no value. This is a lookup field. I can not use hasvalue method becuase the primary key of the lookup list is not nullable.

See attached code. Is there any work around?

Thanks.

NEW POST: Null Value exception

RajKrishnan — Sat, 29 Mar 2008 04:49:51 GMT

When I access a sharepoint list field with a null value (no entry), I get an exception error.

I have suucessully connected to the list and I am trying to populate a SQL Server Compact Edition (sdf) database. When I interate throuhg the query, if a filed has null value, it gives me an error and I had to work around using try / catch exception. I am sure there is a better way and I am missing something.

HEre is a portion of the code:

string conn ="|DataDirectory|\\Schedule.sdf";
DataContext ds = new DataContext(conn);
Table<ScheduleData> Schedules = ds.GetTable<ScheduleData>();
Table<Rooms> Rms = ds.GetTable<Rooms>();
Table<Resources> Rsc = ds.GetTable<Resources>();

var ct = new ScheduleDataSharePointDataContext();
var dt = from p in ct.MTCEngagements
where p.StartDate12 > DateTime.Today.AddDays(-1)
orderby p.StartDate12
select p;
//ct.Log = Console.Out;
//ds.Log = Console.Out;

foreach (var q in dt)
{

string lead= null;
try
{
lead = q.Lead.ResourceAlias; // I get an error if the Lead.ResourceAlias is null.......

}
catch (Exception)
{
lead = "None";
}

.........

COMMENTED ISSUE: Not working when list is not on root web

danleis — Mon, 17 Mar 2008 22:07:49 GMT

Hi Bart,
Generation tools are not working when site is not at the root. for example http://localhost/site/MyPublishingSite gives an error "cannot connect to sharepoint". The site must be at the root "http://localhost"
Comments: ** Comment from web user: danleis **

Hi Bart,
I had the same situation, so I had to modify the ObjectModelSharePointDataProvider constructor to support SPWeb as a parameter. I also changed the related class members and the generator code, so now I can work on lists not on the root site of the site collection. Actually I would be happy to share my improvements and ideas with the community, but I do not know how I could join the project.
Thanks
Daniel

NEW POST: SP0099: Unsupported query expression detected.

ViktorBergman — Mon, 17 Mar 2008 11:45:13 GMT

smartin wrote:
You can use SharePoint Explorer http://blog.mondosoft.com/ontolica/archive/2007/02/15/SharePoint-Explorer-for-WSS3.aspx

Thank you very much! This looks like a great tool, awesome!. So here's my SchemaXML for the field:

<Field Type="Text" DisplayName="S-Order" Required="FALSE" MaxLength="255" ID="{e938e162-c1c3-49c5-9971-793673a16765}" SourceID="{304f80d5-33ab-460d-b0a8-743c4638223f}" StaticName="Sx002dOrder" Name="Sx002dOrder" ColName="nvarchar5" RowOrdinal="0" Version="2"><Default /></Field>

NEW POST: SP0099: Unsupported query expression detected.

smartin — Mon, 17 Mar 2008 09:48:38 GMT

You can use SharePoint Explorer http://blog.mondosoft.com/ontolica/archive/2007/02/15/SharePoint-Explorer-for-WSS3.aspx

NEW POST: SP0099: Unsupported query expression detected.

ViktorBergman — Mon, 17 Mar 2008 07:38:40 GMT

smartin wrote:
Please, attach some detailed information regarding your custom field. SchemaXml would be nice - like this: <Field ID="{038D1503-4629-40f6-ADAF-B47D1AB2D4FE}" Name="Company" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Company" Group="Core Contact and Calendar Columns" DisplayName="Company" Type="Text" />.

Ok, but how do I get the SchemaXML of the field out of sharepoint. I have looked in the database but cannot find where the fields are stored.
Thanks!

NEW POST: SP0099: Unsupported query expression detected.

smartin — Fri, 14 Mar 2008 14:00:35 GMT

Please, attach some detailed information regarding your custom field. SchemaXml would be nice - like this: <Field ID="{038D1503-4629-40f6-ADAF-B47D1AB2D4FE}" Name="Company" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Company" Group="Core Contact and Calendar Columns" DisplayName="Company" Type="Text" />.

NEW POST: SP0099: Unsupported query expression detected.

ViktorBergman — Fri, 14 Mar 2008 08:19:50 GMT

In my "Tasks" list in Sharepoint I have specified serveral custom columns. They all get mapped correctly in the SPML but once i try to query against it i get "SP0099: Unsupported query expression detected.". If I remove the WHERE against the column and simply enumerate the results and print out the column value i get nothing, the value is nothing...although in sharepoint it does have a value.

I am running:
MOSS 2007
VS2008 (project targetted at 3.5)

The column is mapped like this in my SPML:
<Field Name="Sx002dOrder" DisplayName="S-Order" Type="Text" Description="Serviceorder" Id="92219223-79d9-46d7-99e9-8811e0ab41c8" />

Thankful for any help! =)