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

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,

Joel

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?


..ßen

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

Joel,

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

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

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

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!