173 reputation
15
bio website
location
age
visits member for 2 years, 10 months
seen Dec 19 at 18:43

Nov
3
accepted Am I using Data Warehousing wrong?
Nov
2
asked Am I using Data Warehousing wrong?
Mar
6
awarded  Popular Question
Jun
13
awarded  Notable Question
Jan
15
awarded  Popular Question
Jul
8
accepted Is executing SQL through a WebService a really bad idea?
Jul
4
comment Is executing SQL through a WebService a really bad idea?
I could deal with something like that, but now I'm curious how most people handle a situation like this? As most people (in this thread anyway) have big frowns on their faces, I'm assuming no one really uses a method like this. They probably just connect directly to the database from the application, implement something like a web service before final deployment, more commonly probably using a development database until apps ready, then switch?
Jul
4
comment Is executing SQL through a WebService a really bad idea?
As far as why I asked the question, it's because I was looking for a better way than using something like a webservice, but it's really one of the only things I know how to do. When an application is changing all the time does it not seem tedious and a little ridiculous to change your code in probably more than 3 spots just so something like your 'GetUser' method returns one more value (bad example but you get the picture)? What you think would be a 30sec job turns into a 15 minute job
Jul
4
comment Is executing SQL through a WebService a really bad idea?
@user16764 i wouldn't
Jul
4
comment Is executing SQL through a WebService a really bad idea?
I'm just trying to figure out a way whenever I make a simple change, or add something new I don't have to make changes in 3 different layers/spots. I used to run everything off of stored procedures, but that became such a burden I switched all the webservice methods to just use parameterized queries within the method.
Jul
4
asked Is executing SQL through a WebService a really bad idea?
Feb
23
awarded  Supporter
Feb
23
awarded  Scholar
Feb
23
accepted Creating Unit Tests on a CRUD layer of an Application, how can I make the tests independent?
Feb
22
awarded  Student
Feb
22
asked Creating Unit Tests on a CRUD layer of an Application, how can I make the tests independent?