Publish Web site with gridview - datasource an Entity Model

SilviaTerzi · Post by **SilviaTerzi** » Thu 02 Jul 2009 10:56

Yes, I've done it but itdoesn't work.

This is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim connectionString As String
connectionString = "metadata=res://*;provider=Devart.Data.Oracle;provider connection string=""User Id=report_demo;Password=demo;Server=ecedis;Home=OraClient10g_home1;Persist Security Info=True"""

Using conn As New Entities(connectionString)
Me.EntityDataSource1.DataBind()
Me.GridView1.DataBind()
End Using
End Sub

But i still see the other database's datas!!!

AndreyR · Post by **AndreyR** » Fri 03 Jul 2009 08:45

Try the following code:

Code: Select all

Dim connectionString As String 
connectionString = "metadata=res://*;provider=Devart.Data.Oracle;provider connection string=""User Id=report_demo;Password=demo;Server=ecedis;Home=OraClient10g_home1;Persist Security Info=True"""
Me.EntityDataSource1.ConnectionString = connectionString
Me.EntityDataSource1.DataBind()

Please let me know if something goes wrong.

SilviaTerzi · Post by **SilviaTerzi** » Wed 08 Jul 2009 13:56

No, it gave me the same error:

Schema specificato non valido. Errori:
Devart.Data.Oracle.Entity.StoreSchemaDefinition.ssdl(2,69) : errore 0169: Tutti gli elementi SSDL devono utilizzare lo stesso provider. ProviderManifestToken 'ORA' diverso da 'Ora10gR2', rilevato in precedenza.

What can I do?

I have done also a second test:

I made two different models that connect to two different db and tried to link one with a grid and one with another. But only work one of two, that one I have refreshed the connection last. At this point I do not know how to do more!

I've sent a zip of my exampl to "'[email protected]'" ma nobody answered me, why?

Thank you in advance for your help,

Silvia

SilviaTerzi · Post by **SilviaTerzi** » Wed 08 Jul 2009 14:50

Hello Andrey,
Thanks for your help.
I've done what you suggest, but now, when I change connection, it says:

Schema specificato non valido. Errori:
Devart.Data.Oracle.Entity.StoreSchemaMapping.msl(3,4) : errore 2002: L'elemento EntityContainer 'SchemaInformation' per il modello concettuale, specificato come parte di MSL, non esiste in MetadataWorkspace.

What can I do? I'm desperate!

By,
Silvia.

AndreyR · Post by **AndreyR** » Wed 15 Jul 2009 06:25

Can you reproduce the problem with the new build?

SilviaTerzi · Post by **SilviaTerzi** » Wed 15 Jul 2009 07:32

Yes, it gave me the same error. I send you zip of my program by email. Please Help me!!!
Silvia