Francisco Figueiredo Jr Activities

I'm a software engineer and creator of Npgsql.
Here you will find info about me and the development projects I work on
If you liked this blog, you should follow me on twitter

Search This Blog

Pages

Home
Npgsql Homepage

More…

Did you like Npgsql? Send us a postcard!

December 15, 2008

Hi all!

Some time ago, a friend of mine, Horita, told me about a project whose owner asked people who liked his software to send him a postcard. I liked the idea and yesterday, while cooking the 2.0.2 release with Josh Cooley, I told him about this idea and he also liked it.

So, if you like Npgsql you can send us a postcard. Here are the addresses:

Josh Cooley
102 Boston Harbour Way
Madison, AL 35758
USA

Francisco Figueiredo Jr.
QMSW 05 Lote 02 Bloco C Apto 116
Sudoeste - Brasilia - DF - Brazil
Zip Code: 70680-500

Thank you very much!

Get link
Facebook
X
Pinterest
Email
Other Apps

Labels

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Anonymous said…

You guys rock!

18 February, 2009 00:46

Anonymous said…

23 February, 2009 06:19

Anonymous said…

In order to " OL/a>" world to be successful, has a powerful secret society is essential to support the so-called "three to help a hero", a secret society is not only a http://www.playerassist.com/dofus/dofus-power-leveling.php the backing of the most solid, more like a extended eveisk in general, are sons and daughters Jianghu Harbor soul. On March the heavy update, " OL" will introduce the "gang stronghold" This unprecedented innovation system. By then, Knight seekers will gather gang stronghold warlords began chase the deer, a prelude to the political arena hegemony!

23 March, 2009 06:44

Npgsql Tips: Using " in (...)" queries with parameters list and "any" operator

May 12, 2009

Hi, all! We have received some users questions about how to send a list of values to be used in queries using the "in" operator. Something like: select foo, bar from table where foo in (blah1, blah2, blah3); Npgsql supports array-like parameter values and the first idea to have this working would try to use it directly: NpgsqlCommand command = new NpgsqlCommand("select * from tablee where field_serial in (:parameterlist)", conn); ArrayList l = new ArrayList(); l.Add(5); l.Add(6); command.Parameters.Add(new NpgsqlParameter("parameterlist", NpgsqlDbType.Array | NpgsqlDbType.Integer)); command.Parameters[0].Value = l.ToArray(); NpgsqlDataReader dr = command.ExecuteReader(); but unfortunately this won't work as expected. Npgsql will send a query like this: select * from tablee where field_serial in ((array[5,6])::int4[]) And Postgresql will complain with the followin...

Get link
Facebook
X
Pinterest
Email
Other Apps

45 comments

Using Entity Framework 6 with Npgsql 2.1.0

February 17, 2014

UPDATE (2014-05-19): Marek Beneš noticed a problem in the default connection factory config. It is fixed now. Thanks, Marek! UPDATE (2014-02-20): I created a new post explaining how to get Npgsql 2.1.0. Although this post is about EF 6, I'd like to talk about our current situation to support both EF 6 and EF4.x which explain why there are some subtle changes between EF 4.x and EF 6.x App.config settings. Support for EF versions 4.x and 6.x Sometime after we started to work on Npgsql 2.1.0, we started to add code to support EF6 and decided to reorganize our Entity Framework support code. Shay created a pull request to organize this change and isolate the EF code out of core Npgsql code. The result was the creation of two separated assemblies: Npgsql.EntityFramework.dll for EF6 and above; Npgsql.EntityFrameworkLegacy.dll for EF4.x. Only when using Npgsql with EF6 you will need to reference Npgsql.EntityFramework.dll assembly. This is needed because the EF ...

Get link
Facebook
X
Pinterest
Email
Other Apps

26 comments

Npgsql Code First Entity Framework 4.3.1 Sample

June 08, 2013

After reading the excellent article about entity framework on Postgresql by Brice Lambson, I decided to write this post to document my experience playing with Entity Framework 4.3.1 and Npgsql. This post will be an adaptation of the Code First To a New Database walkthrough in order to make it work with Npgsql. First Steps You should follow the first 4 steps of Code First To a New Database. Go ahead, I''l wait for you. Next steps Here is where the adaptation of the walkthrough begins. As Brice noted in his post, Npgsql currently doesn't support database creation. ( I'm working on that and hope to get news about it soon.) So, for while, you have to create the database manually. Those are the steps you have to do to create the database and the model: First, run this command in the terminal to create the database (or you can use pgAdmin if you prefer a GUI): > createdb ef_code_first_sample After that, you have to run the following commands ...