DevForce Community Forum : Code first PostgreSql http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Code first PostgreSql Wed, 13 May 2026 07:58:12 -700 Wed, 07 Mar 2012 14:02:43 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3315 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Code first PostgreSql : Hi Thomas,You will need to... http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12910#12910 Author: sbelini
Subject: 3315
Posted: 07-Mar-2012 at 2:02pm

Hi Thomas,
 
You will need to set the DefaultConnectionFactory. We talk about this topic in the DevForce Resource Center.
 
For PostgresSQL/Devart specifically, you might want to take a look at: http://www.devart.com/blogs/dotconnect/index.php/using-entity-framework-power-tools-ctp1-with-oracle-mysql-postgresql-and-sqlite.html#using.
Be sure to also write an implementation of IDbConnectionFactory. (as shown in the link above)
 
Regards,
   Silvio.
]]> Wed, 07 Mar 2012 14:02:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12910#12910 Code first PostgreSql : Connection string for model... http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12899#12899 Author: Thomas
Subject: 3315
Posted: 05-Mar-2012 at 9:50pm

Connection string for model first:

connectionString="metadata=res://*/model.EBModel.csdl|res://*/model.EBModel.ssdl|res://*/model.EBModel.msl;provider=Devart.Data.PostgreSql;provider connection string="User Id=postgres;Host=localhost;Database=postgres;Persist Security Info=True;Schema='""ETERADEV""'"" providerName="System.Data.EntityClient"

And when I get the error I am using CodeFirst (ModelFirst is working).

I get the error when I compile the solution with an included .CF file (as I said, you can try it if you modify the demo WPF CodeFirst to use the devart provider instead of SqlServer)


Edited by Thomas - 05-Mar-2012 at 9:52pm]]> Mon, 05 Mar 2012 21:50:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12899#12899 Code first PostgreSql : Hi Thomas,I'm confused.... http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12896#12896 Author: sbelini
Subject: 3315
Posted: 05-Mar-2012 at 5:10pm

Hi Thomas,
 
I'm confused. Are you using ModelFirst or CodeFirst?
 
When you create an edmx based on an existing PostgreSql DB, what does the connectionSting look like?
 
Regards,
   Silvio.
]]> Mon, 05 Mar 2012 17:10:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12896#12896 Code first PostgreSql : I tried to use your model first... http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12886#12886 Author: Thomas
Subject: 3315
Posted: 04-Mar-2012 at 6:34am

I tried to use your model first WPF tutorial application and when i changed the connection string to 

<add name="CodeFirstWalk" connectionString="User Id=postgres;Host=localhost;Database=postgres;Persist Security Info=True;Schema='&quot;ETERADEV&quot;'" providerName="Devart.Data.PostgreSql" />

I got 

An error occurred during metadata generation and a metadata file could not be created.  Error: Keyword not supported: 'host'. G:\Program Files (x86)\MSBuild\IdeaBlade\IdeaBlade.DevForce.Common.targets 110 5


If you want to try it out just install the Devart PostgreSql provider and change the string.


Edited by Thomas - 04-Mar-2012 at 6:35am]]> Sun, 04 Mar 2012 06:34:53 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3315&PID=12886#12886