StrataFrame Forum

VistaDB 3 Support?

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

By Joel Meikle - 7/4/2007

Hi all, I'm new to the world of StrataFrame & was wondering if its possible to use a VistaDb v3 database (since is self contained & managed).



I saw a post about it somewhere but wanted to know if the "Businesss Object Mapper" would work with it?



If it dosen't, would it still work if I wrote the Business Objects by hand?



(More likely I would write a script gen using MyGeneration, did this for Opf3 & Xpo)



I also noticed that you get the source code when you purchase, does this include the "BOM"?



Is anyone else using StrataFrame with VistaDb 2/3?



Cheers,

Joel BigGrin
By Trent L. Taylor - 7/5/2007

Hi all, I'm new to the world of StrataFrame & was wondering if its possible to use a VistaDb v3 database

At present we do not have a provider pre-built in the framework fo VistaDB.  The primary reason for this is that since version 2.0 of .NET and SQL Everywhere and SQL Express, there really hasn't been much of a demand for VistaDB....since the SQL performs faster, is managed, and is free Smile 

I saw a post about it somewhere but wanted to know if the "Businesss Object Mapper" would work with it?

If you connect using their OLEDB provider then you can use the BO Mapper by selecting the OLE DB option.  As for a native connection, no.

If it dosen't, would it still work if I wrote the Business Objects by hand?

The BO is actually ignorant of the database and this would be more at the data access level....which you could connect using OLEDB or write your own data layer by inheriting the DbDataSOurceItem and then creating your own DAL for the VistaDB using their native .NET assembly.

I also noticed that you get the source code when you purchase, does this include the "BOM"?

You get the source code for all run-time components and since the BO Mapper is a design-time component and part of how we license our product, you do not get the source code to this piece.

Is anyone else using StrataFrame with VistaDb 2/3?

I will let someone else answer this one if they choose to Smile

By Ben Hayat - 7/5/2007

Joel;



Sometime ago, before DBVista was sold to the new owner, I was looking into it for an embedded application and did some reading in different forums. One thing that I found out that DBVista suffers in performance in large data volume. Based on some tests, it was very slow, especially when data was retrieved that were spread among multiple files. Just wanted to bring this up, in case you're considering DBVista for application that captures large data.



At that time (before I joined SF) I was looking at XPO from DevExpress, and they too had problems working with DBVista, which the problem was on DBVista side. Hopefully, the new management have resolved these issues.
By Joel Meikle - 7/5/2007

Thank you all for your feedback, I currently use VistaDB for a few small projects & its great. I agree that for any larger project that it needs to be somthing more powerful like sql server etc.



I currently use XPO & Opf3 as my ORMappers & they work great but I wanted to see what StrataFrame had to offer & it looks like alot!.



Thanks again, Wink

Joel
By Ben Hayat - 7/5/2007

I currently use XPO & Opf3 as my ORMappers & they work great but I wanted to see what StrataFrame had to offer & it looks like alot!.
Joel; just to shed some light on your quest, I wanted to say that XPO and Opf3 are merely used as ORM. SF, not only offers the ORM, it also offers many other aspects of a developent framework that you have to develop on your own, i.e., security, validation, database deployment and versioning, concurrency, 3-tier/remote usage, messaging, localization, browse/search dialog, many UI controls, themes and many others.



Developing .Net apps, without proper tool can be real chore!



Does DBVista have OLEDB support?
By Joel Meikle - 7/5/2007

Cheers for the reply Ben,



I am aware that XPO & Opf3 a pure data access (ORM) & not a framework, I stareted using these ages ago before I was aware of the power of application frameworks & their advancements.



VistaDB doesn't have a oledb provider for its latest version. It does have a ado.net provider but thats not much help here.



I think their older ActiveX version has an oledb provider but haven't heard of anything for the latest version.



Cheers,

Joel
By Trent L. Taylor - 7/6/2007

Joel,

Is there anything preventing you from using SQL Server in your environment or do you just have a preference to VistaDB?

By Joel Meikle - 7/6/2007

Hi, I use sql server for larger projects where I know there will be a data server & lots of clients.



I use vistaDB for small programs (1-2 users) & where the database needs to be portable (e.g. easily zipped & emailed to me or copied from one machine to another).



I don't like MS access for the file bloating (especially over a shared network) although MS access does have its used (e.g. XPO can auto generate & databases & update schema which is cool for small single user projects).



I am currently looking into Sql Everywhere to see if its possible to use this & syncronized databases without a sql server.



I like using vistaDB because I can programatically update the schema & syncronize very easily.



Cheers,

Joel
By Joel Meikle - 7/6/2007

Hi, I use sql server for larger projects where I know there will be a data server & lots of clients.



I use vistaDB for small programs (1-2 users) & where the database needs to be portable (e.g. easily zipped & emailed to me or copied from one machine to another).



I don't like MS access for the file bloating (especially over a shared network) although MS access does have its used (e.g. XPO can auto generate & databases & update schema which is cool for small single user projects).



I am currently looking into Sql Everywhere to see if its possible to use this & syncronized databases without a sql server.



I like using vistaDB because I can programatically update the schema & syncronize very easily.



Cheers,

Joel
By Trent L. Taylor - 7/6/2007

I like using vistaDB because I can programatically update the schema & syncronize very easily.

This is the entire purpose of our Database Deployment Toolkit and the DatabaseMigrator class.  It allows structures (and data) to be easily deployed to SQL Server without any scripting!