|
SOAP/HTTP for database access? Isn’t one a framework for the other? I wasn't aware either could speak with a database.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
You can really use SOAP/HTTP to talk directly to a DB. You can format a query in a SOAP message and send it via HTTP and then parse the response form the server. But there has to be a web service on the server that will respond to your request for this to work.
|
|
|
|
|
msmiddleton1 wrote: But there has to be a web service on the server that will respond to your request for this to work.
Yea that's kinda what i figured. Still need something else to talk directly with the database. Wonder why it made the list?
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
it should not have made the list, it doesnt directly talk to the db, the dev will use one of the above options in conjunction with this abstraction layer.
|
|
|
|
|
Signal-9 wrote: it doesnt directly talk to the db, the dev will use one of the above options
Thanks for confirming what I had thought.
I'm rather surprised Chris put it in the list.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
I've understand it in such a way: "Do you access databases over Internet?". Or so.
Very legitimate.
Regards,
Gennady
|
|
|
|
|
I've done a project about a year ago which uses HTTP to get data from a web interface of a database. It used to parse the HTTP response and to store it in an MS Access database for further processing using OLEDB. Even though it had something to do with HTTP, I don't think this would make it into the SOAP/HTTP category.
.: Shall I push the button? :.
|
|
|
|
|
Its an option for those developers who are abstracted from the "low level" DB access. Take for example the majority of developers at Amazon.com that probably interact with the various systems via SOAP/HTTP.
Todd Smith
|
|
|
|
|
I haven't used another data access method since switching to NHibernate. It uses ADO.NET under the hood, but it's abstract enough that it should get its own entry.
|
|
|
|
|
Nah, I discovered that everything else except self-crafted DB-layers seem to have one or another thing that I dislike or are unpractical.
Event the VS.NET-generated strongly typed DataSets didn't fit my needs.
Usually I simply create my own wrapper classes and manually generated "Load()" and "Store()" methods.
|
|
|
|
|
.NET can handle XML documents pretty well. Don't ask about how huge can be the XML files, but, with reasonable sizes, it works excellent. I had my own XML against a custom schema and it was working fine using .NET datasets. I have simulated also a resx editor using XmlDataDocument and ResX XML format. And all this datasets could be bound to .NET datagrids. So, the ADO.NET results percent could increase a lot
Dan Radu
|
|
|
|
|
What are the pros vs. cons of each access method? Not being a database guru I never really knew which one to prefer. I just hope that it works
Todd Smith
|
|
|
|
|
Todd Smith wrote: I never really knew which one to prefer.
Keep a eye on the poll results.. , that will tell you the one widely in use and it would probably be the one to prefer
L.W.C. Nirosh.
Colombo,
Sri Lanka.
|
|
|
|
|
Well its not that i don't like it or the database is for girls. All of the project till now didn't require one.
I am not sure, if ADO.NET works with xml type database, I haven't checked it, but someone told me that you can have xml file as database via ADO.NET, is it true? if yes, i would certainly be interested in it.
-Prakash
|
|
|
|
|
Mr.Prakash wrote: Well its not that i don't like it or the database is for girls.
Hey, don't mock the Khan++
|
|
|
|
|
Nishant Sivakumar wrote: Hey, don't mock the Khan++
-Prakash
|
|
|
|
|
If you a serialized classes databaseso you surly could. So you must take care of all indexation.....head.. troubles
Only Visual C++ and C# dreams are allowed.
|
|
|
|
|
Hm... odd. Databases (despite how much I hate them) seem ubiquitous these days. I can't remember when I wrote an app which didn't use some kind of database (be it relational, file based, hierarchical, whatever).
--
Please rise for the Futurama theme song
|
|
|
|
|
I don't develop for windows system, my projects are for mobile handset.
-Prakash
|
|
|
|
|
Hi , though i was thinking XMLs are the answer to store data i was wrong in the case of Mobile Pocket PCs as it somehow has trouble writting the file. If the file size is larger than 200KB then i wouldnt suggest XML. Recently i wrote a solution which tends to have problem appending data where reading goes fine but writting back fails some times. Test before u think of implementation on XML throughly (Mobile Devices).
Rakesh Salian
|
|
|
|
|
Here, if you are interested[^]. Do I like it? No. Thankfully, it is deeply buried under three abstraction levels, so I don't need to handle it directly. In fact, I don't like MySQL at all
Historically, I have used ODBC (through MFC and DTL), ADO, OLEDB templates (these are nice), ADO.NET, Berkley DB API, even some JDBC.
|
|
|
|
|
Long back, for my first job, I had to write a wrapper class (on Linux with GNU C) to handle Postgres and MySQL natively Wasn't fun - incorrect and vague documentation, and not much online info. Luckily the wrapper didn't have to be comprehensive as the database requirements were rather simplistic.
|
|
|
|
|
Nishant Sivakumar wrote: Long back, for my first job, I had to write a wrapper class (on Linux with GNU C) to handle Postgres and MySQL natively
Luckily, I didn't have to do that - the wrapper was already in place when I joined the team. Of course, I still need to construct some ugly SQL queries now and then (for some reason, we don't use stored procedures, although they are available with MySQL 5.x), but it is far from being my main responsibility
|
|
|
|
|
On the other hand, if you've learned one SQL API, you pretty much know them all. At least when it comes to the C-based ones. I have yet to find an API which is radically different than all other APIs.
--
Smell-o-vision users, insert nostril tubes now
|
|
|
|
|
^ true... however i found the MYSQL C API pretty easy to get going with.
|
|
|
|