ADO.NET

We read all your feedback reports to know how we may make our products better. The opinion of our users is important to us. Unfortunately, substantial part of user feedback reports rate our documentation as poor.

Last couple of months we have been working on dotConnect for Oracle documentation improvement. We have made improvements in two directions:

1. Better table of contents, improving of current articles and writing new ones.
2. Improving class reference (increasing number of samples, extending descriptions)

You can download the latest version of our documentation here. Older version of this documentation can be downloaded here for comparison.

We would like to know your opinion on the documentation changes, and which problems need more detailed coverage.

According to the list of core functions in SQLite, there is no native support for the most mathematics functions (sqrt, log, etc). Furthermore, user may need non-standard functions for his own task (e.g. conversion Celsius to Fahrenheit). This issue can be resolved with user-defined functions (UDFs).

Support for UDFs is added to dotConnect for SQLite starting with the 2.50 version. UDF provides a mechanism for extending the functionality of the SQLite engine by adding a function that can be evaluated in the SQL statements of SQLiteCommand. For more information, please refer to our documentation to the SQLiteAggregateFunction, SQLiteCollationFunction, SQLiteScalarFunction classes (there are samples of using them). Full support for user-defined functions and collating sequences means that in many cases if SQLite doesn’t have a feature, you can write it yourself in your favorite .NET language. Writing UDF’s and collating sequences has never been easier.
(more…)

According to this post in the ADO .NET team blog, Microsoft deprecates OracleClient as a part of ADO.NET roadmap. Microsoft strongly recommends customers to use  third-party ADO.NET providers for Oracle  instead of continuing to use Microsoft’s OracleClient for new application development.

Devart offers dotConnect for Oracle – fast and reliable ADO.NET provider for the wide range of users. Our ADO.NET provider is the most compatible with OracleClient provider, and it provides the easiest migration from OracleClient. It allows you to migrate easily without effort.
(more…)