Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
- Posts: 5
- Joined: Thu 09 Jun 2011 16:19
I am using Devart DotConnect for Postgresql. Devart.Data.Postgresql version is 18.104.22.168
I have different schemas on a single database and I'm trying to connect to a schema called, say "test1".
My connectionstring (which I pass to the constructor of Entitites object) is as follows:
Code: Select all
string="Server=localhost; Port=5432;User Id=xxxxxx;Database=xxxxxx;Unicode=true;
when I create the new Entities object with this connection string, I try to call db.CreateDatabase() I expect the tables to be generated on schema "test1" but it tries to create them on "public". I get an error like this;
"relation Notification already exists" CREATE TABLE public.
"Id" bigserial NOT NULL,
I used Initial Schema="test1"
in the connection string but the entity object uses public
Why is this happening?
- Site Admin
- Posts: 8245
- Joined: Thu 14 Aug 2008 12:44
Seems like your Notification table has the "Schema=public" attribute in SSDL (Store) part of the model. You should clear the Schema value in design-time with Entity Developer
(or with XML Editor in case of EDM Designer).