SQL Reporting Web Services

I'm building a web app I'm trying to get around coding CRUD for all my web services. I have some weird constraints because I'm integrating in to a dod product.

Can I use SQL Reporting services web services (SQL 2008 R2) to query my database like in 2005 with endpoints? If so Do you have to build reports for each table or can you just get WSDLs for your database.

If not any options for not writing a lot of code for all my tables

WCF is not an option. I wish..
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I'm not sure I entirely understand what you're trying to do, but at a high level the SSRS web services provide the ability to list and execute/render reports sitting on the report server.  The reports themselves are what would actually communicate with your database, so you aren't going to want to use SSRS as a makeshift data access layer.  I will say, however, that this is certainly a viable option for pulling data out of your database and displaying it on the web.

If you are looking for a simple data access layer I would suggest .netTiers, it is very fast to get up and running and provides pretty solid web services.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JasonPJohnsonAuthor Commented:
Codesmith is kinda what i'm looking for.

I am just trying to avoid writing out web services CRUD for my databases.

It seems that adobe flex wont consume atom or json based WCF data services.
JasonPJohnsonAuthor Commented:
Code smith is a life changer
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.