|
ASP.NET Membership Provider, Role Provider and Profile Provider
VistaDB.Web.dll includes providers and an ASP.NET wizard to add required tables
to existing database, or to modify structures from SQL Server migrated database.
A new Visual Studio template also makes adding them to your project easier than
ever.
|
|
TSQL Procs and User Defined Functions
TSQL Procs and UDFs allow you to migrate existing SQL Server procedures to VistaDB
with minimal effort. VistaDB is the world's first non Microsoft product
to support SQL Server compatible TSQL Procs. There are limitations, and some
syntax is not supported. Read the help file for more information.
Screenshots
|
|
Fully managed and typesafe C# architecture
To maximize integration with the .NET Framework VistaDB was designed and developed
from scratch using C#. The core database engine, the T-SQL compatible query processor,
the ADO.NET Data Provider, the Direct Data Access™ objects and the data management
tools are all developed in fully managed and typesafe C#.
|
|
Native support for Mono
VistaDB is 100% managed code. Since we have no dll imports or unsafe calls we can
run on Mono where the platform supports all required classes. There are a few open
issues with some of the classes in Mono, and the WinForms support is not quite there
yet (but they have improved a lot).
Many of our customers ship VistaDB with Mono for cross platform support. Graffiti
CMS, BlogEngine.net and many others are shipping products today cross platform thanks
to Mono and VistaDB.
We suggest you test your product with your target platform to see if Mono fully
supports everything you need. We do not provide technical support for Mono
installations or deployments.
NOTE: There is a known issue with PowerPC Mono and VistaDB.
|
|
SQL Server 2005 compatible data types and T-SQL syntax
VistaDB is highly compatible with SQL Server 2005 data types and supports T-SQL
syntax so developers can easily re-use existing code developed for SQL Server 2005
with minimal changes. This new level of compatibility lets developers move between
SQL Server and VistaDB with ease.
Screenshots
|
|
Visual Studio 2008 and 2010 Server Explorer support
VistaDB is integrated tightly into the Visual Studio 2008 and 2010 IDE. Support
for Visual Studio's Server Explorer means you can connect to and use VistaDB databases
as you would SQL Server. Version 4 includes the ability to create databases, create
and alter tables, indexes and views all within Visual Studio. Direct launch of the
Data Builder from within Visual Studio is also now supported.
New templates have been added in for Visual Studio to allow you to create new database
projects even faster. The templates copy the runtime to the bin folder, and
even create the app.config or web.config for your application.
Screenshots
|
|
Data Migration Wizard
The new Data Migration Wizard provides improved support for migrating data from
Access and SQL Server. New support for migration scripts lets you define custom
rules for migrating data and gives you more control than ever before.
Screenshots
|
|
Data Builder provides visual data management
VistaDB Data Builder lets you visually create databases, tables, views, indexes
and lets you run interactive V-SQL on your data. This utility is actually a fully
managed Win Forms application developed using VistaDB and C#.
We include a sample project (DBA Sample Tool) that is a non-branded version of the
Data Builder. This source allows you to quickly build an admin tool for your
application and brand it for your company.
Screenshots
|
|
Managed CLR Procs and CLR Triggers
CLR Procs let you create and store managed procedures using C# or VB.NET into assemblies
that can be registered with your VistaDB databases. Once created, you can call your
custom CLR Procs from your application to perform various data management tasks.
CLR Procs are more powerful than traditional stored procedures since your code has
access to the entire .NET framework
Screenshots
|
|
|
TSQL Procs and User Defined Functions
TSQL Procs and UDFs allow you to migrate existing SQL Server procedures to VistaDB
with minimal effort. VistaDB is the world's first non Microsoft product
to support SQL Server compatible TSQL Procs. There are limitations, and some
syntax is not supported. Read the help file for more information.
Screenshots
|
|
Support for Views
VistaDB provides support for updatable Views. You can write SQL statements to create
virtual views of data from one or more tables. With this feature, we now supports
a full migration of the ubiquitous Northwind database. Views are not the same
performance as an actual SQL Query. They are considered virtual tables that
have to be created for the query to be run.
Screenshots
|
|
Primary Key and Foreign Key support
Relational databases allow data to be stored in normalized order so as to avoid
storing redundent information. Support for Primary Key and Foreign indexes lets
you define well-designed databases.
|
|
Analysis of VistaDB architecture
Microsoft MVP Ralf Westphal digs deep into the VistaDB architecture using Lattix
LDM to provide a technical analysis of the VistaDB architecture. Ralf even compares
the quality of VistaDB's architecture to the .NET 2.0 Framework itself. Over 400
VistaDB classes get scrutinized!
Read Ralf's Blog...
|