VistaDB - .NET - V3.3 (Build 49) - Resumen
de VistaDB Software - Tipo de producto: Componente / ASP.NET WebForms / .NET WinForms / .NET Class / 100% Managed Code
Resumen
VistaDB V3.3 by VistaDB Software
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.
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
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
PartNumbers: PC-517570-143327 517570-143327 PC-517570-143328 517570-143328 PC-517570-143330 517570-143330 PC-517570-143331 517570-143331 PC-517570-143332 517570-143332
Publisher PartNumbers: VB30SUBU VDB30SITE VDB30SRC VDB30SUB VDB30SUB5
PurchaseOptions: VistaDB V3.3 (Build 49) - Managed database for .NET, CF and Mono 1 Developer License with 1 year Subscription , VistaDB V3.3 (Build 49) - Managed database for .NET, CF and Mono 5 Developer License with 1 year Subscription , VistaDB V3.3 (Build 49) - Managed database for .NET, CF and Mono 1 Developer Subscription License Upgrade from V3.0 1 Developer No Subscription License , VistaDB V3.3 (Build 49) - Managed database for .NET, CF and Mono 1 Source Edition License with 1 year Subscription , VistaDB V3.3 (Build 49) - Managed database for .NET, CF and Mono 1 Site License (Source, Single Location, 1 year Subscription)
Resources: Read the VistaDB Whitepaper, Read the VistaDB DataSheet, Read the VistaDB License Agreement, Download the VistaDB Demo, Download the VistaDB V3.3 (Build 49) evaluation on to your computer - Expires after 30 days
Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows NT 4.0
Architecture of Product: 32Bit, 64Bit
Product Type: Component
Component Type: ASP.NET WebForms, .NET WinForms, .NET Class, 100% Managed Code
Built Using: Visual C# .NET
Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft SQL Server 2005, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0
Product Class: Business Components
Keywords: Vista Vister Visda VistaDB DB SQL Database JET engine data validation validate Mining analyze analyse analysis データ分析 SQL query language Database DB Management Database DB Connectivity Storage Store Professional Partner Database SQL data query table Mono
Enlaces
