Hi,

 I am evaluating your product and have hit a small problem. The generated code fails to compile. I am using the Oracle client with support for LINQ turned on (this is the main reason I am looking at EntitySpaces). In one of the generated files I get the error, "Error 11 'atk.ls.WcfEntitySpaces.BusinessObjects.esSecondaryContainment' does not contain a definition for '_UpToChamberByChamberId' and no extension method '_UpToChamberByChamberId' accepting a first argument of type 'atk.ls.WcfEntitySpaces.BusinessObjects.esSecondaryContainment' could be found (are you missing a using directive or an assembly reference?)". The table in question has the following definition:

Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
GEO_AREA_ID                               NOT NULL VARCHAR2(8)
CHAMBER_ID                                NOT NULL NUMBER(38)
CONTAINER_ID                              NOT NULL NUMBER(38)
HUMIDITY_SETPOINT_PCT                              NUMBER(38)
UPPER_HUMIDITY_LIMIT                               NUMBER(38)
LOWER_HUMIDITY_LIMIT                               NUMBER(38)
CONTAINER_TYPE_ID                                  NUMBER(38)

The error occurs twice, once in the GeoAreaId setter and once in the ChamberId setter. Here is the relavant code.

1    		/// <summary>
2    		/// Maps to SECONDARY_CONTAINMENT.GEO_AREA_ID
3    		/// </summary>
4    		virtual public System.String GeoAreaId
5    		{
6    			get
7    			{
8    				return base.GetSystemString(SecondaryContainmentMetadata.ColumnNames.GeoAreaId);
9    			}
10   			
11   			set
12   			{
13   				if(base.SetSystemString(SecondaryContainmentMetadata.ColumnNames.GeoAreaId, value))
14   				{
15   					this.MarkFieldAsModified(SecondaryContainmentMetadata.ColumnNames.GeoAreaId);
16   					this._UpToChamberByChamberId = null;
17   				}
18   			}
19   		}
20   		
21   		/// <summary>
22   		/// Maps to SECONDARY_CONTAINMENT.CHAMBER_ID
23   		/// </summary>
24   		virtual public System.Decimal? ChamberId
25   		{
26   			get
27   			{
28   				return base.GetSystemDecimal(SecondaryContainmentMetadata.ColumnNames.ChamberId);
29   			}
30   			
31   			set
32   			{
33   				if(base.SetSystemDecimal(SecondaryContainmentMetadata.ColumnNames.ChamberId, value))
34   				{
35   					this.MarkFieldAsModified(SecondaryContainmentMetadata.ColumnNames.ChamberId);
36   					this._UpToChamberByChamberId = null;
37   				}
38   			}
39 		}

The errors occur on lines 16 and 36. This seems like a bug to me.

 Any ideas?

Thanks,

 Mike

I did generate all of my tables at once with the "Generate Hierarchical Model" checked. I am looking at this because of a post to the Oracle forums with the home EntitySpaces URL claiming to support LINQ to Oracle. If that isn't the case, then I don't need to proceed with the evaluation.

 So does EntitySpoaces support LINQ to Oracle?

 Thanks,

Mike