SQL connection on a web service

[Andrea]

I'm building my first webservice and I've some doubt about the life's
cycle.
Teorically a webservice is consumed and dead just after it has released
the information for which it has been built.

So, because I've to use the webservice like a bridge to store sql info
on a SQL Server table, how can I make sql connection persistent?
Just to avoid sql connection create and destroy process every time.

Thanks
Andrea

[Saverio Tedeschi]

Hi Andrea.
if you need a persistent connection, how about a replication scenario
instead of Web svc?
On the other side, Web svc consuming is tipically disconnected, while svc
itself could be or not.

"Andrea" <andrea.moro@web-ma.com> ha scritto nel messaggio
news:1121518394.787992.222360@g47g2000cwa.googlegr oups.com...

> I'm building my first webservice and I've some doubt about the life's
> cycle.
> Teorically a webservice is consumed and dead just after it has released
> the information for which it has been built.
>
> So, because I've to use the webservice like a bridge to store sql info
> on a SQL Server table, how can I make sql connection persistent?
> Just to avoid sql connection create and destroy process every time.
>
> Thanks
> Andrea
>

[Jurjen de Groot]

..NET keeps a pool of SQL connections 'alive', this way SQL connections are
re-used and not recreated every time you do a 'cn.open'. for SQL connections
to be 'pooled' they'd have to have to exact same ConnectString.

HTH,
Jurjen.

"Andrea" <andrea.moro@web-ma.com> wrote in message
news:1121518394.787992.222360@g47g2000cwa.googlegr oups.com...

> I'm building my first webservice and I've some doubt about the life's
> cycle.
> Teorically a webservice is consumed and dead just after it has released
> the information for which it has been built.
>
> So, because I've to use the webservice like a bridge to store sql info
> on a SQL Server table, how can I make sql connection persistent?
> Just to avoid sql connection create and destroy process every time.
>
> Thanks
> Andrea
>