I have some existing WCF code that accesses SQL Server 2005, but honestly I've come to mistrust that developer's methods, so I want to know how this should be done correctly and professionally. I need to be able to pass an SQL statement to a method that returns the resultant dataset. I'm not interested in entity frameworks or other abstraction layers. I need to run SQL, DML, and hopefully DDL too.
I also want to know how to re-use the same connection for the lifespan of the service rather than open and close a connection for each call.
Please point out your thoughts on better alternatives if you feel like it. I'm prepared to listen.
No comments:
Post a Comment