VistaDB - .NET - V3.3 (Build 49)

Descrizione generale | Prezzi e licenze | Valutazioni e download | Compatibilità | Dati autori | Recensioni | Forum | Sommario

Ti preghiamo di notare che le informazioni su questi prodotti non sono disponibili in italiano.
Fully managed and embedded SQL database for Microsoft .NET, Compact Framework & Mono. VistaDB 3 has been redesigned and redeveloped using Visual C# to be a fully managed and typesafe embedded SQL database engine designed specifically for Microsoft .NET Framework, Compact Framework and Mono. VistaDB 3 enables developers build fully managed and typesafe ASP.NET and WinForms database applications using any CLR compliant language, such as C# and VB.NET. Single and multi-user applications can be developed with VistaDB that run on desktops, mobile devices and web servers. Mobile applications run natively on Microsoft Windows Mobile 5.0 for Smartphone and Pocket PC and Windows Pocket PC 2003 operating systems. Compatibility with SQL Server 2005 data types and T-SQL query syntax allows database to be easily migrated and existing T-SQL code to be re-used. Support for Mono makes VistaDB 3 a flexible cross-platform database solution that allows your .NET applications to run on Windows, Linux, Mac OS X and other flavors of Linux unchanged.

I nostri prezzi standard sono indicati sotto. Accedi per vedere i tuoi prezzi scontati.

VistaDB V3.3 (Build 49) - Managed database for .NET, CF and Mono

I nostri prezzi comprendono l'assistenza tecnica ComponentSource e, per la maggior parte dei prodotti scaricabili, una copia di riserva online e un aggiornamento GRATUITO alla nuova versione, se questa viene lanciata entro 30 giorni dall'acquisto.  Tutte le vendite sono soggette ai nostri termini e condizioni standard ed alla nostra politica di rimborso.  Contattaci se necessiti di un'opzione di licenza non elencata sopra, comprese licenze multiple e versioni precedenti.

I nostri prezzi standard sono indicati sopra. Accedi per vedere i tuoi prezzi scontati.

What's New in V3.3?

• TSQL Procs – You can now run TSQL Stored Procedures in VistaDB.
• TSQL User Defined Functions – with support for any return type.
• Improved SQL compliance with SQL Server – SQL parser has been improved.
• New SQL Syntax – While / Break / Continue syntax is now supported along with other improvements.
• Temp Tables support – Tables that live only for the lifetime of your connection, or for the execution of a stored proc.
• Licensing changes are included in this final build. You are now prompted for your serial number during setup. This key is transmitted via SOAP to a webserver that generates a license file for your machine.
• Truly embedded ADO.NET 2 SQL database for .NET 2+, CF 2 and Mono
• Less than 1 MB single assembly deployment
• Cross-platform Windows, Linux and Mac OS X support using the Mono Project
• Easy migration from SQL Server TSQL
• Royalty-free distribution
• TSQL Error handling with TRY CATCH support in stored procedures

Features
Database Engine

• 100% fully managed and typesafe architecture and is CLSCompliant marked
• Small < 1MB Footprint with true XCopy deployment
• Royalty-free distribution
• Developed in C#
• Cross-platform support: Windows, Linux, Mac OS X, Sun Solaris & BSB
• Built-in SQL Server 2005 T-SQL compatible query processor
• Built-in ADO.NET Providers for each platform
• Built-in Direct Data Access™ objects (DDA)
• ASP.NET Allow Partially Trusted Callers (APTC) attribute
• ASP.NET Isolated Storage support for alternate way to manage data
• Thread safe
• ZeroClick™ deployment allows engine to be fully embedded into your application using ILMerge so there are zero additional files to deploy
• Allow Partially Trusted Callers Attribute (APTC)
• Custom VistaDBDataTable component
• Single and multi-user support
• Simultaneous multiple connection support
• Database level, table level and row level locking
• In-memory databases and tables
• XML import and export
• Dynamically create and modify databases
• Connection Pooling
• Transaction Processing (ACID)
• Read Committed isolation for Transaction Processing
• Side-by-side multiple version deployments can co-exist
• Schema's can be altered using shared mode access
• Diagnostics
• Write-behind data caching
• Support for |DataDirectory|
• Shared hosting compatible with Medium Trust support (Allow Partially Trusted Callers Attribute ATPC)
• Data Types are 1:1 compatible with SQL Server 2005
• Fully managed Data Builder GUI application include C# source in licensed version
• Updatable SQL Views
• Compact Framework 2 support for Windows Mobile 5 for Smartphone and PocketPC
• Same database file format for Mobile and Desktop devices
• No CPU or RAM limits (included 64 bit support)
• Single database file, may be custom named and deployed using XCopy
• Read only media supported – run your database from a CD-ROM or DVD

Database Features

• Database supports up to 4TB
• Single file data store (.VDB3 database file)
• SQL Server 2005 compatible data types
• UNICODE support (NChar, NText, NVarChar)
• Secure Blowfish encryption (32-bit to 448-bit)
• Schema can be altered in Shared Mode
• Views
• CLR Procs™
• Constraints
• Primary Keys and Foreign Keys
• Referential integrity
• Cascading deletes and updates
• Disk space can be reclaimed
• Granular encryption of database, tables or columns
• Password protect database
• Primary and secondary indexes
• Compression attribute for columns
• Relationships
• Dynamic default values using functions
• Identity Types
• Image data storage (i.e. BLOB)
• Extended properties (table and column descriptions etc.)
• Database allows custom file extensions
• Variable length rows
• TSQL Stored procedures compliant with SQL Server 2005 syntax
• TSQL User Defined Functions (UDFs)
• Temp table support – Both within stored procedures and table as a variable for returns.
• Isolated storage support
• Full database encrypting with Blowfish
• Full Text Search indexes for text columns
• Updatable SQL Views

Data Management Tools

Data Builder Tool

• Visually creating and manage database schemas
• Run interactive SQL
• Query Plan support
• Browse, add and edit data
• Visually manage CLR Procs™
• Manage Tables, Columns, Indexes, Relationships, Primary and Foreign Keys
• Graphically build TSQL Procedures and User Defined Functions (UDFs)

Data Migration Wizard

• Migrating data from SQL Server, SQL CE, VistaDB 2.x and Access to VistaDB 3.0
• Supports silent mode data migration
• Automatically generates migration logs and re-usable migration scripts
• Command line scripting support for using with install applications
• Source included with full version

Types of Applications Supported

• ASP.NET applications
• ASP.NET Membership provider source included
• Windows Forms (WinForms) applications
• Windows Services applications
• Windows Console applications
• Mono Gtk# for Linux Desktop and Web Services
• Mono Glade for Linux Desktop and Web Services

Languages Supported

• C# (includes samples)
• VB.NET (includes samples)
• Other CLR-compliant languages (e.g. Delphi.NET, J# etc.)

IDE Support

• Visual Studio 2008  with Server Explorer – non Express editions
• Visual Studio integration includes ability to graphically build TSQL Procs and UDFs within Visual Studio
• Visual Studio 2005 with Server Explorer with non-Express Editions
• Visual Studio .NET 2003 with DataAdapter Wizards with non-Express Editions
• ASP.NET WebMatrix via code
• SharpDevelop via code
• Borland Developer Studio via code

Platforms Supported

• .NET Framework 3.0
• .NET Framework 2.0
• .NET Framework 1.1
• 64-bit .NET Framework
• Compact Framework 2.0
• Mono 1.x

Supporto

Subscription benefits include:

• Unlimited priority tech support
• Weekly development build
• Free upgrades to new engines (Not Server)
• Archive downloads
• Subscriber only forums
• Auto update utility to check for updates