Main > Network & Internet > Database Utils >

dotConnect for SQLite Standard 3.60.258



 

dotConnect for SQLite Standard 3.60.258

Sponsored Links

dotConnect for SQLite Standard 3.60.258 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 10.3 MB
Platform: Windows All
License: Freeware
Price: $0
Downloads: 13
Date added: 2011-12-10
Publisher: Devart

dotConnect for SQLite Standard 3.60.258 description

dotConnect for SQLite Standard 3.60.258 brings you a convenient, lightweight and effective data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications.

As a part of the Devart database application development framework, dotConnect for SQLite offers both high performance native connectivity to the SQLite database and a number of innovative development tools and technologies. dotConnect for SQLite introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.

Benefits:

  • Wide Coverage of SQLite Features
    • By providing access to the most advanced database functionality, dotConnect for SQLite allows developers to harness the full capabilities of the SQLite database engine and optimize their database applications. dotConnect for SQLite stands out as the set of components with the widest support of SQLite functionality.
  • Optimized Code
    • The goal of dotConnect for SQLite is to enable developers to write efficient and flexible database applications. The dotConnect for SQLite assemblies are implemented using optimized code and advanced data access algorithms. Components undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers.
  • Comprehensive Support for ADO.NET Technology Features
    • dotConnect for SQLite supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, and so on. dotConnect for SQLite will continue supporting the newest standards and innovations of the .NET Framework.
  • Database Application Development Extensions
    • dotConnect for SQLite has a rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers for typed SQLite-specific components, toolset for live data binding and much more. dotConnect for SQLite integrates tightly with Visual Studio 2005/2008/2010, Delphi, and SQL Server 2005 Business Intelligence Solutions.
  • Provider-Specific Technologies
    • dotConnect for SQLite has extra components designed to simplify some tasks and support SQLite-specific technologies. Particularly, SQLiteScript serves to execute series of SQL statements, and SQLiteDump serves to backup or restore a whole database or its parts.
  • ADO.NET Entity Framework Support
    • ADO.NET Entity Framework is a conceptual approach to database application development with focus on objects instead of relational data.The flexible architecture of Entity Framework is made up of well-thought layers and modules. Entity Framework optimizes the development process with object-relational mapping, SQL-based entity query language, and LINQ.
    • dotConnect for SQLite supports the Entity Framework capabilities, which allows you to base your object-oriented applications on SQLite. All standard Entity Framework samples can be easily ported to dotConnect for SQLite.
  • LinqConnect
    • dotConnect for SQLite includes support for LinqConnect technology. The technology allows you to employ object-oriented database application development with less efforts and in less time. Compared to ADO.NET Entity Framework, LinqConnect is better suited for RAD-style development, is easier to start with, and somewhat richer with server-oriented features like server-specific types. See LinqConnect tutorial for a quick start with the technology.
  • Both Connected and Disconnected Models
    • dotConnect for SQLite combines connected and disconnected data access models in a single SQLiteDataTable component, that allows you to design more flexible application architecture and use full power of data binding.
  • Development and Support
    • dotConnect for SQLite is a SQLite connectivity solution that has been actively developed and supported since 2007. dotConnect for SQLite comes with full documentation, demo projects, and fast (usually within one business day) technical support by the dotConnect for SQLite development team.

Major Features:

  1. General usability
    • Real RAD for database applications
    • Fully compliant with ADO.NET
    • 100% managed code
    • Highly usable design time support
    • Easy to deploy
  2. Compatibility
    • Full support of the latest versions of SQLite
    • Full support for x64 architecture
    • Microsoft Visual Studio 2005, 2008, and 2010 support
    • CodeGear RAD Studio 2007 support
    • Embarcadero Delphi Prism support
    • SQL Server 2005 Business Intelligence Solutions support
  3. SQLite technology support
    • All SQLite data types support
    • User-defined functions support
    • SQLiteDump component to store a database or its parts as a script and then restore it
    • The CEROD and SEE extensions support
    • Ability to enable extensions with the EnableLoadExtension connection string parameters
  4. Performance
    • High overall performance
    • Intelligent fetch block size control
    • Advanced connection pooling
    • High performance batch processing
  5. ADO.NET technology support
    • Support for ADO.NET Entity Framework v1 and v4
    • LinqConnect (formerly known as LINQ to SQLite) support
    • Batch update support
    • Extended metadata information retrieval
    • Enhanced pooling control through connection string
    • Connection string builder
    • Provider factory for generating key data access classes
    • Asynchronous command execution
    • Provider-specific types support
  6. ADO.NET Entity Framework
    • Conceptual approach to enterprise development
    • High performance
    • Wide support for LINQ to Entities
    • Wide support for EntitySQL
    • Full CRUD (Create, Retrieve, Update, Delete) support
    • Wide support for server data types
    • Change tracking support
    • Object data caching
    • Inheritance mapping support (TPH, TPT, and TPCT models)
    • Capability to use stored procedures when manipulating data
    • Stored procedure import support
    • Ability to build database-independent applications
    • Visual Studio EDM Wizard support
    • Reverse engineering of database objects to entity model
    • Visual model creation and code generation with Entity Developer
      • Update Model From Database functionality for Entity Developer[New]
      • Update To Database with Mapping Synchronization functionality for Entity Developer[New]
  7. LinqConnect (formerly known as LINQ to SQLite)
    • Easy to use
    • High performance
    • Interchangeable with Microsoft LINQ to SQL
    • Plain CLR classes used (no need to use a common base class)
    • Full CRUD (Create, Retrieve, Update, Delete) support
    • Ability to execute DML statements in batches on SubmitChanges [New]
    • Complex type support
    • PLINQ support (connection manager redesigned for thread safety) [New]
    • Support for different configurable algorithms for primary key generation
    • Inheritance mapping support (Table Per Hierarchy and Table Per Type) [New]
    • Support of Visual Studio Debugger Visualizer for the DataQuery objects [New]
    • ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates [New]
    • Automatic configurable compiled query caching
    • Change tracking support
    • Object data caching
    • Data binding support
    • Wide support for LINQ capabilities
    • Wide support for server data types
    • Load on demand (lazy load)
    • Database transactions support
    • Server-independent interface
    • Visual model creation and code generation with Entity Developer
      • Update Model From Database functionality for Entity Developer[New]
      • Update To Database with Mapping Synchronization functionality for Entity Developer[New]
    • Illustrated tutorial to get started with LinqConnect in 5 minutes
  8. Extended data access technologies and functionality
    • Powerful SQLiteDataTable component for manipulating individual tables or query result
    • NonBlocking mode allows fetching data asynchronously in the background
    • On-demand data fetch for data-bound controls
    • Paginal access to query result
    • Server side master-detail relation based on queries
    • Support for Enterprise Library Data Access Application Block (DAAB)
    • Object-oriented building of SELECT statements
    • Extended warning and error information retrieval
    • Extended interface for processing execution exceptions
    • SQLiteDataAdapter.Fill method with sequential fetch support
    • Ability to defer fetching of some columns in a resultset
    • Named parameters support
  9. WinForms-specific features
    • Flexible data binding with DataLink component
    • InterForm technology for cross-form components cooperation
    • Global position synchronization within a data source
  10. ASP.NET-specific features
    • ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
    • SQLiteDataSource web component
    • SQLiteCacheDependency component to control Cache item dependencies in ASP.NET applications
  11. Script execution
    • Advanced script execution features with SQLiteScript component
    • Support for executing individual statements in scripts
    • Support for executing huge scripts stored in files with dynamic loading
  12. SQL execution monitoring
    • Extended SQL tracing capabilities with SQLiteMonitor component
    • Support for dbMonitor utility for advanced tracing analysis and control
    • Per-component SQL tracing
    • Optional log output to IDE toolwindows
  13. Design-time enhancements
    • Automatic component registration in toolbox
    • Advanced integration with Visual Studio 2005, 2008, and 2010, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SQLiteDataSource
    • DataSet Wizard to create and edit typed SQLite-oriented datasets
    • DataSet Manager to list and bind datasets in the project
    • DataSet Editor to edit dataset contents
    • Advanced design-time component and property editors
    • IntelliSense descriptions for dotConnect for SQLite classes
    • Syntax highlighting in design-time editors
    • TableMappings editor
    • Convenient instant data preview and management in design time
  14. Product clarity
    • Complete documentation sets integrated into Visual Studio and CodeGear Delphi
    • Integration with Visual Studio and MSDN help collections
    • Documentation available as a standalone chm file
    • A large amount of helpful demos in C#, VB, C++, and Delphi
  15. Licensing and support
    • Included annual dotConnect for SQLite Subscription with Priority Support
    • Licensed royalty-free per developer, per team, or per site

Enhancements:

  • LinqConnect (formerly known as LINQ to SQLite)
    • The bug with inserting both sides of a one-to-one relationship is fixed
  • Entity Developer
    • Capability for customizing the default Type Mapping Rules is implemented
    • Capability for setting diagram options either globally for all diagram documents or separately for a particular one is implemented: the Diagram Appearance and Printing options can now be set through the Options dialog box
    • Capability for setting such options as Environment, Diagram and Servers' to adjust the Entity Developer behavior, Model diagram behavior and Type Mapping Rules to your needs is implemented
    • Capability for setting and defining the class property validation rules based on different engines (Data Annotation, Enterprise Library, NHibernate Validator) is added
    • The 'Integer Primary Key As Identity' SQLite option is added: if this option is checked, the "StoreGeneratedPattern" will be set to Identity by default for Integer primary keys
    • The HasStream attribute of entity types, used retrieve binary data as a stream via Open Data Protocol, is supported (Entity Framework models)
    • The bug with code generation for foreign key fields in Entity Framework models with fluent mapping is fixed
    • The bug with code generation for default values of DateTime fields is fixed (LinqConnect models)
    • The bug with 'losing' additional diagrams when re-opening a model is fixed
  • Entity Framework support
    • The behavior of the Database.Delete code-first method is changed: the constraints are now disabled when database objects are deleted
    • The config.QueryOptions.NoEscapeLike option is implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith()
    • The bug with generating AUTOINCREMENT in DDL for key columns when using Identity in Code First is fixed
    • The bug with generating ON DELETE CASCADE in SQL when using Code First is fixed 

Requirements:

  • SQLite Compatibility
    • dotConnect for SQLite supports SQLite engine version 3 and higher.
  • Framework Compatibility
    • The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0. The product is compatible with ADO.NET Entity Framework v1 and v4.
  • IDE compatibility
    • dotConnect for SQLite and can be used with the following development environments:
      • Microsoft Visual Studio 2010
      • Microsoft Visual Studio 2008
      • Microsoft Visual Studio 2005
      • Embarcadero Delphi Prism
      • CodeGear RAD Studio 2007
    • There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and DDEX integration. As an exclusion, Visual Web Developer supports DDEX features.
    • RAD Studio 2007 is supported in run time only as these environments have no WinForms designers.
  • Devart data providers compatibility
    • Since Devart data providers use a common assembly (Devart.Data.dll), it is necessary to make sure that all installed data providers are compatible.
    • dotConnect for SQLite can be used together with dotConnect Universal that provides universal access to different databases within a single code

dotConnect for SQLite Standard 3.60.258 Screenshot

dotConnect for SQLite Standard 3.60.258 Keywords

Bookmark dotConnect for SQLite Standard 3.60.258

Hyperlink code:
Link for forum:

dotConnect for SQLite Standard 3.60.258 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for dotConnect for SQLite Standard 3.60.258. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
Wondershare PPT2Flash Standard is the most trustied PowerPoint to Flash Conversion tool, it can be launched within MS PowerPoint. Free Download
SmartCodestudio is the industry-leading label design and barcode software. It provides many features like WYSIWYG label design, image acquisition, image/vector graphics, rich text, 2600+ label templat Free Download
Recovery for SQL Server fixes corrupted MS SQL Server database files. It restores corrupted tables, views, stored procedures, triggers, indexes etc. Both standard and user-defined data types are recov Free Download
Have you ever been in situation that you need to change text, header, footer, comments, OLE object links, hyperlinks or even more in thousands of files and you had to open each file manually to make c Free Download
The Ad Hound Site Submitter Free Download
Welcome to SELLIT Sales & Management Software. Discover SELLIT, the latest sales and marketing system - the high-performance solution for handling all your data requirements with an emphasis towards s Free Download
The Stackz flashcard visualization concept helps to keep the overview over a large amount of words to be learned. The cards are graphically distributed according to the two characteristics mastery lev Free Download
FormsAssistant makes it easy to create new forms, modify existing ones, and fill forms with the appropriate information all within Microsoft Word. Free Download