PostgreSQL database call

From: Mark (field027_at_idonotlikejunkmail.umn.edu)
Date: 12/19/04 

Date: Sun, 19 Dec 2004 12:08:10 -0600

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

Relevant Pages

  • Re: dataadapter update special logic
    ... I guess for the purposes of this, i can probably use a stored procedure (as ... easily done via sql)? ... and then have the update command on your data adapter use ... >> call and put a bunch of .net code in to work with the records being ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procedures - Patterns and Practices
    ... >published the reasoning behind its opinions. ... I disagree that the debate in SQL Server related discussion forums ... If the natural key is long or spans too many ... I want to call a stored procedure that adds a customer ...
    (microsoft.public.sqlserver.programming)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... how do I go about analyzing a stored procedure with selecting ... Is there any tool in the SQL Profiler that analyze each Trace? ... "Active Server Pages error 'ASP 0113' ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... I've installed a brand new copy of SQL Server 2000 with the original ... I've created the folowing stored procedure for the resync ... Resync Command: ALL_CUSTOMERS_RESYNC? ... I need to upgrade to a newer version of Microsoft SQL ...
    (microsoft.public.access.adp.sqlserver)