Is it possible to create an entity that does not have identifier and that relates to a view in the database?

Good morning all !

I created a view in my database that has three fields: Name, SiteUrl, NbPostings (that is the number of postings messages on the forum which site url is SiteUrl by the user Name).

Now I want to display informations that are in this view in a Business Data List Web Part. Then I added in the BDC Application definition XML file the following code :


Answer this question

Is it possible to create an entity that does not have identifier and that relates to a view in the database?

  • Jassim Rahma

    Hi Roxane,

    we've not got views working with BDC Meta Man yet, although that will hopefully change in the version after the one we are soon to release.

    Many thanks

    Nick



  • selinux

    Hi Nick,

    Thank you for your help. I tried to add an entity without an identifier and it works! As they say in the msdn library, you can use it only with Business Data List Web Part and Business Related List Web Part when the entity does not have an identifier: http://www.sharesquared.com/blogs/bobmixon/resources/moss/bdc/default.aspx (on the link Business Data Catalog : Metadata Model). However it did not work, with the Meta Data Man tool when I tried to drag and drop a view from my Database.

    Roxane


  • Michael Mortensen

    Hi,

    I'll be honest I've not tried returning a Finder without an identity column, but from reading the SDK it looks like it should need one:

    "To qualify for a Finder, the corresponding method must take filterable parameters as input and return collections of records, where each record must contain the key of the entity instance it represents." I made the last bit bold

    The other thing you could try is having the method as a Generic Invoker. That can be used if you are creating your own web part with the BDC object model, but I'm not sure that the method would be able to be used with the out of the box web parts.

    Hope that helps

    Nick



  • Is it possible to create an entity that does not have identifier and that relates to a view in the database?