Spl3.0 officially released! Supports multiple types of database access!

Source: Internet
Author: User
Tags spl

SPL 3.0 officially released, Litre Level description

After a period of modification,SPL Finally rose3.0 To be promoted3.0 , Mainly because two connection methods are added:ODP. net AndODBC

ODP. net Greatly enhancedSPL PairOracle Database access capability, currently usedODP. net ConnectionOracle Is the best choice, relatedArticleYou can find it on the Internet. There are quite a few.

ODBCYes. Net framework1.1New features can be used for other types of databasesODBC.

Therefore, the above two connection methods are enhancedSPLMore powerful support for multiple databases.

spl3.0 in the previous version, 2.0 basically revised some bugs


1. Pair Oracle An error is reported when the database compares dates. Oracle The date SQL Similarly, you can directly use the string method, but use To_date () Conversion, currently Oracle The database connection is automatically converted in this respect and supports the following connection types: Oracle And ODP

2.An error occurred while deleting multiple primary keys,3.0In useEntity. Delete ()No error will be reported.

3. Spl2 For numeric Columns Addmatch () , Addmatchprefix () , The system reports an error, 3.0 This has been fixed 3.0 All Match The Operation also takes effect for numeric columns.


Spl3New features:

1. Added a pair ODP. net Connection Oracle This is the current . Net Connection Oracle The best connection method is to install ODP. net92 , In SPL Database Configuration Databasemap Used in Type = "ODP" You can..

2. added top of query, this top function is the same as retrievecriteria , it mainly acts on the SQL environment, because SPL uses top to generate " select Top N , therefore, Oracle currently does not support this method.

3. Condition Suffix matching is added to the condition class.AddmatchsuffixWill generateLike ' % AA ' Effect

4. Conditiont The suffix mismatch function is added to the condition.Addnotmatchsuffix,SimilarNot like ' % AA ' Effect

5. AddedObdcConnection support, in. NetAvailableSystem. Data. obdcAs long as the database connection is configuredType = ' ODBC ' You can useObdcConnection mode. The connection method is described in a separate chapter.

6.Extended connection mode to enableSPLIt is no longer limited to the following Connection Methods:Setting. instance (). databasemapfile = server. mappath (databasexml );

Instead, you can manually add data connections and manually configureClassmapLoad, which is convenientSPLIntegration with other systems. There will be a separate chapter on data connection.

7. for Stored Procedures commandtimeout control is added. Because stored procedures are sometimes time-consuming during execution, you need to manually control commandtimeout . The default value is 30 seconds, 0 is unrestricted. Overwrite runprocedure as follows:

Query. runprocedure (string storeprocname, idataparameter [] ps, string dbname, int commandtimeout)

Query. runprocedure (string storeprocname, idataparameter [] Param, out int affected, string dbname, int commandtimeout)

The publishing method is the same as that of last 2.0. You only need to download my example.Source code , Detailed instructions:
Smartpersistencelayer 3.0 sample source Code Download: http://files.cnblogs.com/tintown/SPL_WebTest3.0.rar
This environment requires support for the netadvantage 2004 Vol 3 ASP. NET control. Since the current online version is changed to 2005 for downloading, I provide download for vol3: Download
Thank you very much for your support for SPL after the release of 2.0.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.