LinqConnect for Silverlight is a fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology, and supporting Oracle, MySQL,PostgreSQL, and SQLite.
LinqConnect for Silverlight is a fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology, and supporting Oracle, MySQL, and PostgreSQL. With it you can develop rich web applications with true ORM support for database access. Moreover, LinqConnect allows using ADO.NET interfaces for working with data, which were not available for Silverlight before. And in addition, it offers its own embedded database engine based on SQLite to store data in isolated storage using a fully functional local relational database. It provides a powerful model designer tool with complete integration to Visual Studio - Entity Developer.
Key Features
Direct connection to Oracle, MySQL, and PostgreSQL databases
Silverlight itself does not provide the way to access data from database servers directly, but with LinqConnect you can use direct database connection without a separate data access layer. It allows you to reduce network traffic and eliminates performance overhead for data serialization and deserialization.
Embedded database engine
Standard Silverlight approach of storing local data in an XML format may be inefficient and not suitable if one needs to store a significant amount of data locally. Having a reliable and convenient storage for local data becomes even more important for Silverlight out-of-the-browser applications that can be installed locally and allow off-line usage, and LinqConnect suits perfectly for these needs. LinqConnect for Silverlight contains the ready-to-use SQLite embedded database engine from C# SQLite project. You don't need to install any additional software, just use LinqConnect to work with a fully-functional relational database in Isolated Storage. Storing data in a relational database offers you a number of advantages - such as transactions, constraints, indexes, and generally provides higher performance and lesser file size. Using relational transactional database also increases reliability of local data storage. Small and efficient, and at the same time powerful SQLite database engine makes LinqConnect a perfect choice to store data locally in Silverlight applications.
LINQ data access
LinqConnect brings you the possibility to use LINQ in Silverlight applications, which grants you such features as compile-time validation, IntelliSense, and your IDE's debugging mechanisms when building and testing your queries, etc.
ADO.NET data access
Though Silverlight does not provide ADO.NET data access, with LinqConnect you can use ADO.NET in Silverlight applications. With LinqConnect you can employ the flexibility and performance of the native database SQL. LinqConnect Silverlight ADO.NET data access allows you to move existing data access code to this platform, providing wider capabilities for porting desktop applications to Silverlight.
Compatibility
LinqConnect uses classes and interfaces completely compatible with LINQ to SQL, while extending its functionality, so LINQ to SQL developer can easily get started to work with LinqConnect.
Actively developed technology
Unlike LINQ to SQL, LinqConnect is an actively developed ORM solution. We keep on improving our product and adding new features based on user feedback.
Professional development team
LinqConnect is developed by a company having more than eight-year experience on the development of the data access technologies in .NET.
Visual model designer
With Entity Developer - a visual model designer, supplied with LinqConnect - all the model creating and editing tasks can be performed in convenient GUI, thus greatly reducing the development and learning time.
Performance
High enough without lots of efforts on optimizing your code.
