StrataFrame Forum

General Software question...

http://forum.strataframe.net/Topic2780.aspx

By Tony Tudyk - 9/12/2006

First, thank you in advance for your time and effort.

I recently downloaded your software and installed it. My question is this:

Will the software pull image metadata from a group of images?

Cheers

By StrataFrame Team - 9/13/2006

Could you clarify what you mean by "image?"  Are you refering to a System.Drawing.Bitmap and how one is serialized into a field on a business object?  Or are you refering to the meta-data of a SQL Server database?  Or something completely different?
By Tony Tudyk - 9/13/2006

I have a client that has over 50,000 images that include metadata. I am trying to catalog them and drop the data into a SQL database and then render back to the web. Thanks again for your time.

Cheers

By Tony Tudyk - 9/13/2006

Sorry, most of the images are .jpgs with some .tiffs mixed in.
By Trent L. Taylor - 9/13/2006

Tony,

This is very possible.  In fact, you can create a VarBinary field in your SQL Server database to house the image.  You can then add a field customization through the BO Mapper in StrataFrame to type this field as a System.Drawing.Bitmap and turn on Serialization.  The BO will then automatically serialize the image to and from the database as an image rather than requiring you to do the work everytime. 

You will want to add these images to the DB through the BO to allow the serialization to take place.  Otherwise you will have a type conversion issue when the BO tries to deserialize the image since it is not in a serialized format.

This is actually what we do for one of our medical products which is a document imaging tool.  We have a mode that stores all of the images in a VarBinary field and does exactly what you are trying to do.  It is a very nice feature.

Let me know if this doesn't answer your question.

By Tony Tudyk - 9/13/2006

Thanks again for your time...I am wondering if you offer services to build the database/tables/queries etc.?

I am very new to SQL and if the cost isn't too high I would be interested in contracting your company to build everything that I need on the database/query end. If you do offer this please give me contact information.

Cheers

By Keith Chisarik - 9/14/2006

The nice thing about Strataframe is their product the Database Deployment Toolkit allows you to create the database in an easy to use tool, then it actually deploys it to the SQL Server for you. I know when I made the move to .NET the one thing I didn't look forward to was learning TSQL, now I dont have to.



I have been using the DDT heavily for about a month and a half and am very pleased. You will still have to learn a few things about security in SQL Server but there is now way around that, and you probably should know it anyway just to be safe.