Hi there,

I am using the LinqMetaData layer and am getting some weird generated code:

We are using LLBGen Pro 2.6, .net 3.5 C#, self servicing..

We are getting a bunch of fields which look like this:

     [LPA_L1].[Latitude]         AS [F7_14],
     [LPA_L1].[Longitude]       AS [F7_15],
     [LPA_L1].[PlaceTypeId]   AS [F7_16],
     [LPA_L1].[PlaceId]       AS [F4_17],

-- [LPA_L1].[F4_18], -- [LPA_L1].[F4_19], -- [LPA_L1].[F4_20], -- [LPA_L1].[F4_21], -- [LPA_L1].[F4_22], -- [LPA_L1].[F4_23],

Unsurprisingly the database is throwing "invalid column name" exceptions

Any ideas?

Please can you post the code which is causing this error ?

Matt

Hi there,

The linq to llblgen query looks like this:

            LinqMetaData lmd = new LinqMetaData();
            var locs = from l in lmd.Location
                       select l;
            foreach (LocationEntity loc in locs)
            {
//              var placesInLoc = from p in lmd.Place
//                                join prl in lmd.ProductRootLocations on p.ContentId equals prl.Spid
//                                where prl.LocationId == loc.LocationId
//                                && p.Status == (short)HB.ContentStatus.Live
//                                select p;

The Place Entity is a sub-entity of the Content Entity, which in turn is a sub-entity of the ID Entity, so LLBLGen generates a series of joins not directly reflected in the Linq

The schema has changed a bit, but not in ways which directly affect this structure. I have regenerated the LinqMetaData class several times.

Not sure where these phantom fields are coming from

thanks for your input

Which runtime library build are you using?

Hi there,

Which binaries specifically?

The ORMSupportClasses & the LinqSupportClasses dlls, please check the below link to know how to get the build/version number. http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7725

Thanks.

Hi again,

SD.LLBLGen.Pro.LinqSupportClasses.NET35.dll 2.6.8.616

SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll 2.6.8.624

Also, the database is SQL Server 2005.

thanks,

These are old enough

Would you please upgrade to the latest releases, and see if the problem still exists.

Thanks, is there a forum post detailing how to upgrade the libraries?

I assume I have to update my various project binaries, as well as the files in the runtimelibraries folder in the LLBLGen Pro v2.6 folder?

I've done it before, but remember being pretty hazy about which binaries to replace, and in what folders.

OK - I see the readme file explains it.

I'll post back after upgrade

Ok - my bad. That seems to have resolved it.

Should have checked all that first.

thanks for the help..