LinqConnect是一個快速而易于使用的ORM(對象關系映射)解決方案,緊密結合Microsoft LINQ to SQL技術,支持SQL Server, Oracle, MySQL, PostgreSQL 和 SQLite。它提供一款強大的完全集成Visual Studio的設計器工具-Entity Developer。
LinqConnect is a fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology, and supporting SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. It provides a powerful model designer tool with complete integration to Visual Studio - Entity Developer.
LinqConnect是一個快速、輕量級且易于使用LINQ to SQL兼容的ORM解決方案,支持SQL Server、Oracle、MySQL、PostgreSQL和SQLIte。它允許用戶為支持.NET框架、Metro、Silverlight或Windows Phone應用程序的代碼優先、模型優先、數據庫優先或混合方法使用高效和強大的數據訪問。
與SQL兼容的LINQ
LinqConnect是與LINQ to SQL緊密結合開發的,并且保持了與它的完全兼容性。LinqConnect類的接口與LINQ到SQL類兼容。如果用戶是LINQ to SQL開發人員,則不需要學習太多,可以立即開始使用LinqConnect進行開發。
與LINQ to SQL不同,LinqConnect是一個積極開發和支持的產品,與LINQ to SQL相比,它支持更多的數據庫服務器、更多的開發平臺、更多的LINQ特性、更多的映射類型、提供更好的性能等等。
代碼第一,數據庫第一,模型第一——都支持
LinqConnect支持所有開發方法——代碼優先、數據庫優先、模型優先,或者混合數據庫優先和模型優先。它的可視化模型設計器Entity Developer允許用戶快速設計模型,并提供易于使用的向導,用于從數據庫中創建模型、從模型中創建數據庫、或在任何方向上同步現有模型和數據庫。Entity Developer提供了強大且高度可定制的基于模板的代碼生成,允許用戶配置代碼輸出重定向、生成部分類、為類和成員使用自定義屬性等。
.NET、Silverlight、Metro、Mono、Windows Phone——共享代碼
共享相同的代碼來處理不同平臺上的數據!LinqConnect是一個數據庫連接解決方案,可以在不同的基于.NET的框架上很好地工作,包括Full.NET Framework、.NET Core、Silverlight、Mono等。除了LINQ數據訪問之外,它還為Silverlight、Metro和Windows Phone提供了ADO.NET接口,而這些平臺以前是不可用的!此外,對于這些平臺,LinqConnect提供了來自C#SQLite項目的托管嵌入式數據庫引擎,用于處理本地SQLite數據庫。
易于與不同的Microsoft技術集成
在Windows窗體、ASP.NET WebForms、WCF RIA服務、動態數據、WPF或其他應用程序中使用LinqConnect進行數據訪問。LinqConnect為Windows窗體和WPF應用程序提供廣泛的數據綁定支持,為ASP.NETWeb應用程序提供LinqDataSource組件,并為動態數據項目和WCF RIA服務提供額外的集成特性。
LINQ支持
雖然大多數ORM使用自己的查詢語言,并且LINQ支持只是一個附加特性,但是LinqConnect被設計為LINQ提供程序,在LINQ和SQL之間沒有額外的層。因為這個LinqConnect具有更高的性能和更好的LINQ支持。
繪圖支持
LinqConnect支持所有廣泛使用的映射情況:復雜類型、多對多關聯、TPT和TPH繼承、將返回光標的存儲過程映射到方法等等。而且它不會因為支持奇異且不必要的映射情況而膨脹——它保持快速、簡單和易于理解。
豐富的運行時特性
LinqConnect具有智能變化跟蹤、高級錯誤處理機制、定制CRUD和其他操作的可擴展性方法、POCO支持、可以在查詢級別定制的惰性和急迫加載等特點。
性能
LinqConnect的性能足夠高,無需花費大量精力優化代碼。LinqConnect包含一組提高性能的解決方案,如編譯的查詢緩存或批量更新。
What is LINQ?
LINQ stands for Language-Integrated Query, which means that data retrieval is no longer a separate language. The LINQ engine allows .NET applications to connect to databases without bothering much about columns and rows. The data you receive is automatically formed as objects ready to use by your business logic.
LINQ to Relational Data may be thought of as an object-relational mapping (ORM) tool. The type-safe LINQ queries get compiled into MSIL on the fly, and the query clauses are translated into SQL and sent to SQL server for execution. This makes your data access layer safer, faster, and greatly more convenient to design.
|
Wide LINQ Support
LinqConnect provides wide support for LINQ queries. It provides advanced eager loading support, enhanced native SQL query handling, and generates better provider-specific SQL code.
|
|
Wide Database Support
LinqConnect works with SQL Server, SQL Server Compact, Oracle, MySQL, PostgreSQL, and SQLite databases, and supports all their scalar data types.
|
|
Compatibility
LinqConnect uses classes and interfaces completely compat- ible with LINQ to SQL, while extending its functi-onality, so LINQ to SQL developer can easily get started to work with LinqConnect.
|
|
Performance
High enough without lots of efforts on optimizing your code. Even higher if you bother to do so. LinqConnect contains a set of solutions for increasing per-formance, such as compiled query cache or batch updates.
|
|
Visual Model Designer
With Entity Developer all the model creating and editing tasks can be performed in convenient GUI, completely eliminating the need of the manual XML editing, thus greatly reducing the devel-opment and learning time.
|
|
Database Providers
LinqConnect goes with bundled Express versions of dotConnect data providers for Oracle, MySQL, PostgreSQL, and SQLite, so you don't need to install additional software to create models.
|
|
Professional Team
LinqConnect is developed by a company having more than eight-year experience on the development of the data access technologies in .NET.
|
|
dbMonitor
Use our freeware dbMonitor tool to monitor and analyze all the database calls, made by LinqConnect components in your application. dbMonitor performs per-component trac-ing of commits, rollbacks, SQL statement execution, etc.
|
|
Support
We provide high-quality techn-ical support for our products. All your forum or e-mail questions will be an-swered in two bus-i-ness days.
|