basic data access with reporting

[todd]

I am trying to learn how to use your data access and reporting modules by creating a very basic project in VS2013 that accesses an oracle database, but i keep coming up with an error.
Here is what i am doing
(just using default names as provided by wizards)
new project -> class library -> add new item -> telerik data access domain model -> select populate from database, backend = oracle -> next -> choose connection -> I have a connection created already from server explorer which works -> name is "connection" -> next -> select the schema i want to use -> select the table i want to use -> next->next->finish -> project gets reloaded -> build solution
add new item -> telerik report q3 2014 wizard -> table wizard -> ok -> add new data source -> select Open Access Data Source -> ok -> choose "connection" as data connection -> choose "ClassLibrary1" and "EntitiesModel1" as object context -> next -> choose IQueryable method that is same name as my table as object context member -> finish -> next -> add my fields (only have 2, one is primary key) -> next -> select normal as style -> next -> finish
report designer is shown -> select preview tab -> get following error
Type is enhanced and registered, but not available from the database class meta data. this can be caused by a wrong connection id or configuration. Parameter name: type Actual value was ClassLibrary1.COURT (COURT is the name of my table)

What am I doing wrong,

[Stef]

Hi Todd,

If connection strings are set correctly and the problem occurs on rebuilding the application this is a known issue already logged into our system for improvement. The logged bug is only a design time problem in Visual Studio 2012+ versions, due to the way assemblies are loaded at design time.

The available workarounds are:

1. Restart Visual Studio after receiving the error in design preview. 
2. Running the report in a report viewer control should not cause the issue.
3. Use the Standalone Designer, where the model must be built in a separate assembly extending the tool's configuration - Extending Report Designer (check also the related KB articles at the bottom).

Let us know if you need any further help.

Regards,
Stef
Telerik

 

 

[Bob]

I am getting this same error and can't use the Preview pane.  Any update on when this will be fixed?  Seems like a pretty large issue if the last three versions of Visual Studio can't be used to preview the report in the Report Designer if you use TELERIK Data Access as the data source (which would seem to be the complete Telerik solution and what you would be highlighting).  I was kind of wondering why none of the demos and very few of the "How To" tutorials on your site use the OpenAccessDataSource (and even then they are just on how to use OpenAccessDataSource)

Surely this is considered a major bug that you have known about for at least 10 months (not sure how long you knew about it before Todd posted this) so please tell me this is coming in the next release.

[Bob]

P.S. the Restart Visual Studio "workaround" does not work in my case.  Not sure if it does for Todd.  And simply not using the preview pane isn't a workaround.

[Stef]

Hi Bob,

This is a known issue on which we spent a significant amount of time and resources.

The problem is related to how Visual Studio loads assemblies and lock them. Thus when the VS Report Designer tries to load the same assemblies to generate the report preview, there are conflicts in duplicating types as they are loaded multiple times.

This limitation of the IDE is listed in the troubleshooting article here. Feel free to log a request for issue in our feedback portal, where requests are considered based on the demand for them.

Regards,
Stef
Telerik