Hi,

Being a newbie (and a student), I need some guidance on how to use the Dicom.DataStore to query data from the database.

Am building a simple user management plugin, and I'd like to be able to access the database using CC's own data-access classes. Writing my own would be just too easy :-)....and generally not "best-practice" or recommended. Why re-invent that wheel?

I've looked at it a bit, made sense of what I could....enough to doubt I can pass raw SQL-statements to the database through the datastore. I need such an ability so that my plugin can create the user's table if it doesn't exist, or to repair it...or something like that. However, if it is possible to create tables  in the database using the objects and functions available in the data-store, do NOT hesitate to correct me and show me how it works. You could even taunt my lack of skill...just help! Yeah, I need it working quick....

Hi, as you've discovered, there's no code in the data store to assist you with adding or modify the structure of the database - it's just a data access layer. It can be used standalone to store and query for DICOM data if that's all you're looking for ... but that's clearly not what you're looking for :)

The part you may be missing is that the data store uses an ORM called NHibernate underneath which does a lot of the mundane database stuff for you ... like generating database tables based on your object model, converting data in multiple tables to/from your object model, etc.

I'm not sure I totally answered your question(s), but if you poke around in the data store code a bit more, and have a look at NHibernate and how it works, I think you might get a clearer picture of what you need to do to accomplish your task.

Best regards,
Stewart

I need Developer's Guide For Image Server

Sorry, the only Developer's Guide there is right now is for the Workstation (viewer).