VistaDB

VistaDB
Database background

VistaDB is a fully-managed embedded .NET database engine compatible with SQL Server. Its selling points are that its’ fully managed, doesn’t have artificial limitations imposed on the database engine and very easy learning curve. To add support for VistaDB to a standard Microsoft .NET application, just add a reference to the VistaDB assembly. All functionality is built into that DLL. SQL CE is a separate driver installation and therefore outside of control of the application developer.

VistaDB can even use the same stored procedures, views and even CLR procedures as SQL Server. A single DLL needs to be redistributed whether the application is 32- or 64-bit. It will use all CPUs/cores of the system.

VistaDB data types we support

Integral:
bigintintsmallinttinyint
Decimal:
decimal (numeric)doublefloat (real)moneysmallmoney
Text:
charncharntextnvarchar (sysname)nvarchar(max)textvarcharvarchar(max)
Binary:
binarybittimestampvarbinary
Date/Time:
datedatetimedatetime2datetimeoffsetsmalldatetimetime
Large objects:
geographygeometryimagentextnvarchar(max)textvarbinary(max)varchar(max)xml
Other:
dynamicobjecthierarchyidsql_varianttableuniqueidentifier