LinqConnect是一個快速而易于使用的ORM(對象關(guān)系映射)解決方案,緊密結(jié)合Microsoft LINQ to SQL技術(shù),支持SQL Server, Oracle, MySQL, PostgreSQL 和 SQLite。它提供一款強大的完全集成Visual Studio的設(shè)計器工具-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應(yīng)用程序的代碼優(yōu)先、模型優(yōu)先、數(shù)據(jù)庫優(yōu)先或混合方法使用高效和強大的數(shù)據(jù)訪問。
與SQL兼容的LINQ
LinqConnect是與LINQ to SQL緊密結(jié)合開發(fā)的,并且保持了與它的完全兼容性。LinqConnect類的接口與LINQ到SQL類兼容。如果用戶是LINQ to SQL開發(fā)人員,則不需要學(xué)習(xí)太多,可以立即開始使用LinqConnect進(jìn)行開發(fā)。
與LINQ to SQL不同,LinqConnect是一個積極開發(fā)和支持的產(chǎn)品,與LINQ to SQL相比,它支持更多的數(shù)據(jù)庫服務(wù)器、更多的開發(fā)平臺、更多的LINQ特性、更多的映射類型、提供更好的性能等等。
代碼第一,數(shù)據(jù)庫第一,模型第一——都支持
LinqConnect支持所有開發(fā)方法——代碼優(yōu)先、數(shù)據(jù)庫優(yōu)先、模型優(yōu)先,或者混合數(shù)據(jù)庫優(yōu)先和模型優(yōu)先。它的可視化模型設(shè)計器Entity Developer允許用戶快速設(shè)計模型,并提供易于使用的向?qū)В糜趶臄?shù)據(jù)庫中創(chuàng)建模型、從模型中創(chuàng)建數(shù)據(jù)庫、或在任何方向上同步現(xiàn)有模型和數(shù)據(jù)庫。Entity Developer提供了強大且高度可定制的基于模板的代碼生成,允許用戶配置代碼輸出重定向、生成部分類、為類和成員使用自定義屬性等。
.NET、Silverlight、Metro、Mono、Windows Phone——共享代碼
共享相同的代碼來處理不同平臺上的數(shù)據(jù)!LinqConnect是一個數(shù)據(jù)庫連接解決方案,可以在不同的基于.NET的框架上很好地工作,包括Full.NET Framework、.NET Core、Silverlight、Mono等。除了LINQ數(shù)據(jù)訪問之外,它還為Silverlight、Metro和Windows Phone提供了ADO.NET接口,而這些平臺以前是不可用的!此外,對于這些平臺,LinqConnect提供了來自C#SQLite項目的托管嵌入式數(shù)據(jù)庫引擎,用于處理本地SQLite數(shù)據(jù)庫。
易于與不同的Microsoft技術(shù)集成
在Windows窗體、ASP.NET WebForms、WCF RIA服務(wù)、動態(tài)數(shù)據(jù)、WPF或其他應(yīng)用程序中使用LinqConnect進(jìn)行數(shù)據(jù)訪問。LinqConnect為Windows窗體和WPF應(yīng)用程序提供廣泛的數(shù)據(jù)綁定支持,為ASP.NETWeb應(yīng)用程序提供LinqDataSource組件,并為動態(tài)數(shù)據(jù)項目和WCF RIA服務(wù)提供額外的集成特性。
LINQ支持
雖然大多數(shù)ORM使用自己的查詢語言,并且LINQ支持只是一個附加特性,但是LinqConnect被設(shè)計為LINQ提供程序,在LINQ和SQL之間沒有額外的層。因為這個LinqConnect具有更高的性能和更好的LINQ支持。
繪圖支持
LinqConnect支持所有廣泛使用的映射情況:復(fù)雜類型、多對多關(guān)聯(lián)、TPT和TPH繼承、將返回光標(biāo)的存儲過程映射到方法等等。而且它不會因為支持奇異且不必要的映射情況而膨脹——它保持快速、簡單和易于理解。
豐富的運行時特性
LinqConnect具有智能變化跟蹤、高級錯誤處理機制、定制CRUD和其他操作的可擴展性方法、POCO支持、可以在查詢級別定制的惰性和急迫加載等特點。
性能
LinqConnect的性能足夠高,無需花費大量精力優(yōu)化代碼。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.
|