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

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

Spl3.0RevisedBug:

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.
Tingtang
2005-1-16