PHP Classes

SQL Server YII DataProvider: Alternative MS SQL Server data provider for YII

Recommend this page to a friend!
  Info   View files Documentation   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 22 All time: 11,185 This week: 455Up
Version License PHP version Categories
ms-active-data-provi 1MIT/X Consortium ...5PHP 5, Databases, Design Patterns


This package is an alternative MS SQL Server data provider for YII.

It extends the YII framework base active data provider class to define how to fetch data for SQL server database queries with given criteria and pagination support.

The package also comes with an example active record class that can be used to show how to perform the necessary queries to retrieve data from the database using implicitly the data provider class from this package.

Picture of Thiago Przyczynski
  Performance   Level  
Name: Thiago Przyczynski <contact>
Classes: 16 packages by
Country: Brazil Brazil
Age: 35
All time rank: 3203237 in Brazil Brazil
Week rank: 301 Up25 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 8x


Yii SQL Server Active Data Provider

This package contains an Active Data Provider to be used instead of Yii 1 builtin CActiveDataProvider to fix the "weird" pagination when using a MS Sql Server database in the Active Records classes.

Installation and Usage

Basically you just need to download this package and put MSActiveDataProvider in the application.components folder (by default: protected/components). After that you may use it in any CModel based class, for instance replacing any call of CActiveDataProvider for MSActiveDataProvider.


You can check the User model sample.

  Files folder image Files  
File Role Description
Files folder imageexample (1 file)
Plain text file MSActiveDataProvider.php Class Class source
Accessible without login Plain text file Doc. Documentation

  Files folder image Files  /  example  
File Role Description
  Plain text file User.php Class Class source

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:11,185
This week:455Up