The Dynamic Data support add-on has been released to the customer area and main site's additional downloads section!

Requirements: - VS.NET 2008 SP1 RTM - LLBLGen Pro v2.6

The archive comes with a readme.txt file which contains the necessary info to get the bits installed and get you up and running in no time .

This archive uses project templates, so creating a dynamic data website with llblgen pro is straight forward (you've to uncomment and alter just a couple of lines, once)

For Dynamic Data specific questions please refer to Microsoft, the MSDN and their forums. If you run into a problem with this add-on and it's LLBLGen Pro related, please post a thread in the general, generated code or templates forums, thanks.

The install.cmd says:

Please run from an elevated Visual Studio 2008 command prompt. Please make sure to close all instances of VS before running.

So do we run this from the command window inside of VS2008 or from outside?

When I try to run from outside in xp with (vs2008 sp1 installed) I get a message:

can not find script file .....\GetVersion.vbs .Net 3.5 RTM must be installed .....

If this post should be elsewhere, feel free to move it.

On a vs.net command prompt, which is available in the tools menu and from the start -> programs menu of vs.net 2008. You can also type vsvars32.bat on a normal command prompt.

The getversion.vbs referral is my error. I'll upload a new .zip file! (I forgot to include it in the .zip)

(edit) new version uploaded.

Thanks, I've gotten it installed. Now on to the testing....

My directories don't look like they work with the cmd you provide.

xcopy /f /y "%SRC%\DynamicDataLLBLGenProAdapterWebApplication.cs.zip" "%VSINSTALLDIR%\Common7\IDE\ProjectTemplates\Web\CSharp\1033\"

My structure looks like

"%VSINSTALLDIR%\Common7\IDE\ProjectTemplates\CSharp\Web\1033\"

Note the flipping of CSharp and Web.

I copied the zips there and ran devenv.exe /installvstemplates. I have the templates now.

Now on to the testing.....

I have a strange error i can not really figure out what's going on, i did everything as should be except one thing (maybe because i'm using adapter scenario ???)

on the line 36 i had to replace the code with this one (simply use another overload)

var modelProvider = new SD.LLBLGen.Pro.DynamicDataSupportClasses.LLBLGenProDataModelProvider( typeof(Xiparo.Assessment.DAL.DatabaseSpecific.DataAccessAdapter), typeof(Xiparo.Assessment.DAL.EntityType), new Xiparo.Assessment.DAL.Linq.LinqMetaData(), new Xiparo.Assessment.DAL.FactoryClasses.ElementCreator());

**But always got this error : **

Server Error in '/' Application.

Internal error: name '' not found in entity 'TextLabelsEntity' Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: SD.LLBLGen.Pro.ORMSupportClasses.ORMGeneralOperationException: Internal error: name '' not found in entity 'TextLabelsEntity'

Source Error:

Line 42: Line 43: // register the modelprovider with the model so DynamicData knows how the model looks like Line 44: model.RegisterContext(modelProvider, config); Line 45: Line 46: // register the datamodelprovider in the application object so it's retrievable in the datasources.

Source File: C:\brol\LLBLGen\WebApplication1\Global.asax.cs Line: 44

Stack Trace:

[ORMGeneralOperationException: Internal error: name '' not found in entity 'TextLabelsEntity'] SD.LLBLGen.Pro.DynamicDataSupportClasses.LLBLGenProEntityRelationProvider.BuildMetaData() +1274 SD.LLBLGen.Pro.DynamicDataSupportClasses.LLBLGenProEntityFieldProvider.get_Association() +49 System.Web.DynamicData.MetaColumn.Create(MetaTable table, ColumnProvider columnProvider) +38 System.Web.DynamicData.MetaTable..ctor(MetaModel metaModel, TableProvider tableProvider, Boolean scaffoldAllTables, String nameOverride) +330 System.Web.DynamicData.MetaModel.RegisterContext(DataModelProvider dataModelProvider, ContextConfiguration configuration) +1511 WebApplication1.Global.RegisterRoutes(RouteCollection routes) in C:\brol\LLBLGen\WebApplication1\Global.asax.cs:44 WebApplication1.Global.Application_Start(Object sender, EventArgs e) in C:\brol\LLBLGen\WebApplication1\Global.asax.cs:76

I have the latest bluegen stuff libraries ....

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

arschr wrote:

My directories don't look like they work with the cmd you provide.

xcopy /f /y "%SRC%\DynamicDataLLBLGenProAdapterWebApplication.cs.zip" "%VSINSTALLDIR%\Common7\IDE\ProjectTemplates\Web\CSharp\1033\"

My structure looks like

"%VSINSTALLDIR%\Common7\IDE\ProjectTemplates\CSharp\Web\1033\"

Note the flipping of CSharp and Web.

I copied the zips there and ran devenv.exe /installvstemplates. I have the templates now.

Now on to the testing.....

I used the install system from the DynamicData preview released by MS, so I assumed they knew how to install it. Strange that your paths are different, as here it installed fine. Which vs.net type do you use, express?

(edit) I see have both paths... strange. (VSTS) I can select them under C# -> Web, and also under Web in File -> New project. I assume you can only select them under 'Web' ?

Muttley wrote:

I have a strange error i can not really figure out what's going on, i did everything as should be except one thing (maybe because i'm using adapter scenario ???)

on the line 36 i had to replace the code with this one (simply use another overload)

var modelProvider = new SD.LLBLGen.Pro.DynamicDataSupportClasses.LLBLGenProDataModelProvider( typeof(Xiparo.Assessment.DAL.DatabaseSpecific.DataAccessAdapter), typeof(Xiparo.Assessment.DAL.EntityType), new Xiparo.Assessment.DAL.Linq.LinqMetaData(), new Xiparo.Assessment.DAL.FactoryClasses.ElementCreator());

The code matches the overload you should use, so you shouldn't use 'another overload', the code is made as-is, ready to be used.

If you use adapter, you should use the ADAPTER specific dynamic data project type, which has the overload properly. If you don't the datasources in the page templates are wrong.

So I assume you picked the selfservicing one while you use a generated adapter llblgen pro project, correct?

Next time i post something later in the evening i should retry things TWICE !

But i still got the same issue, 2 things which can be of importance :

The root namespace is quite long "Xiparo.Assessment.DAL" But probably more important is that the database tables are in multiple schemas "Assessment.Template", "Master.textLabels" ... on SQL2005 But i never had any issue with LLBLGen concerning schemas.

Internal error: name '' not found in entity 'TextLabelsEntity' Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: SD.LLBLGen.Pro.ORMSupportClasses.ORMGeneralOperationException: Internal error: name '' not found in entity 'TextLabelsEntity'

Source Error:

Line 42: Line 43: // register the modelprovider with the model so DynamicData knows how the model looks like Line 44: model.RegisterContext(modelProvider, config); Line 45: Line 46: // register the datamodelprovider in the application object so it's retrievable in the datasources.

Source File: C:\brol\LLBLGen\WebApplication3\Global.asax.cs Line: 44

Stack Trace:

[ORMGeneralOperationException: Internal error: name '' not found in entity 'TextLabelsEntity'] SD.LLBLGen.Pro.DynamicDataSupportClasses.LLBLGenProEntityRelationProvider.BuildMetaData() +1274 SD.LLBLGen.Pro.DynamicDataSupportClasses.LLBLGenProEntityFieldProvider.get_Association() +49 System.Web.DynamicData.MetaColumn.Create(MetaTable table, ColumnProvider columnProvider) +16 System.Web.DynamicData.MetaTable..ctor(MetaModel metaModel, TableProvider tableProvider, Boolean scaffoldAllTables, String nameOverride) +272 System.Web.DynamicData.MetaModel.RegisterContext(DataModelProvider dataModelProvider, ContextConfiguration configuration) +758 WebApplication3.Global.RegisterRoutes(RouteCollection routes) in C:\brol\LLBLGen\WebApplication3\Global.asax.cs:44 WebApplication3.Global.Application_Start(Object sender, EventArgs e) in C:\brol\LLBLGen\WebApplication3\Global.asax.cs:76

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

Muttley and others, please don't flood this thread with technical problems related to Dynamic Data, as stated in the first post, please post a new thread in one of the forums mentioned: general, generated code or templates. Thanks.

Muttley wrote:

Next time i post something later in the evening i should retry things TWICE !

But i still got the same issue, 2 things which can be of importance :

The root namespace is quite long "Xiparo.Assessment.DAL" But probably more important is that the database tables are in multiple schemas "Assessment.Template", "Master.textLabels" ... on SQL2005 But i never had any issue with LLBLGen concerning schemas.

That's all irrelevant, database tables aren't read, you're using an o/r mapper

You didn't mention if you're using adapter or selfservicing. Please remove the dynamic data site you created and start over. Also please continue in a new thread (you may refer to this thread / post (see '#' link) in that thread. Thanks.

Which vs.net type do you use, express?

No, Pro.

(edit) I see have both paths... strange. (VSTS) I can select them under C# -> Web, and also under Web in File -> New project. I assume you can only select them under 'Web' ?

Yes, under web. I don't have a high level group called web only Visual C#, Business Intellegence, Other languages, Other project types, and Test Projects.

However. After I did this tweak and followed the other instructions in your read me the dd website came up and works (on the entities I tested).

I need to find out now how to enhance the default results, in particular adding better filtering. Selecting an entity with 700,000,000 rows in the table doesn't work very well

arschr wrote:

Which vs.net type do you use, express?

No, Pro.

(edit) I see have both paths... strange. (VSTS) I can select them under C# -> Web, and also under Web in File -> New project. I assume you can only select them under 'Web' ?

Yes, under web. I don't have a high level group called web only Visual C#, Business Intellegence, Other languages, Other project types, and Test Projects.

Thanks, I'll add something to the readme about this.

I need to find out now how to enhance the default results, in particular adding better filtering. Selecting an entity with 700,000,000 rows in the table doesn't work very well

it should do paging though, though I think it's due to the # of related entities (1:n relations) for the filters at the top.

They simply pull all related elements into a combobox ( ) to filter it. I ran into this as well when I was writing the code back in april and reported it to them, as with AdventureWorks it already didn't work (which resulted in webpages over 100K lines long ) and they said they're looking into filtering / search features if the related table is big. Though these things of course didn't make it till RTM, so it's unknown when (or if) they'll release this. They did offer some enhancements in the preview on their website over at codeplex but I haven't checked it.