PostgreSQL database call

[Mark]

I would love to see a snippet of .NET code that either:
1. Executes a raw SQL statement against MySQL or PostgreSql.
2. Executes a stored procedure on PostgreSql.

Ideally both examples would require a parameter ... for example, a select
statement with a where clause that has a changing parameter value - not hard
coded. in sql server, a stored procedure like this would be ...

create proc blah
@person_id int
as

select * from sometable where person_id = @person_id
go

But again, I'm not intersted in the SQL itself - I want to see the .NET code
that calls similar SQL/stored procedure code on MySQL or PostgreSql.

Thanks in advance!

Mark

[Mark]

http://gborg.postgresql.org/project/...UserManual.htm
http://dev.mysql.com/downloads/connector/net/1.0.html
http://dev.mysql.com/tech-resources/articles/dotnet/

"Mark" <fi******@idonotlikejunkmail.umn.edu> wrote in message
news:Oo**************@tk2msftngp13.phx.gbl...

I would love to see a snippet of .NET code that either:
1. Executes a raw SQL statement against MySQL or PostgreSql.
2. Executes a stored procedure on PostgreSql.

Ideally both examples would require a parameter ... for example, a select
statement with a where clause that has a changing parameter value - not hard coded. in sql server, a stored procedure like this would be ...

create proc blah
@person_id int
as

select * from sometable where person_id = @person_id
go

But again, I'm not intersted in the SQL itself - I want to see the .NET code that calls similar SQL/stored procedure code on MySQL or PostgreSql.

Thanks in advance!

Mark