|
Irwsoft.Data is SQL object mapper for .NET framework.
A simple design and powerfull framework for working
with SQL-database. This is a solution for software
developement that doesn't want to bother with sql construction.
Using Visual Studion intellisense as a hints to develpers working
with SQL database easily, because they are .NET class.
Platform
- .NET Framework 2.0 and above
Database
- Any OleDb's database that supported by ADO.net
- Microsoft SQL Server - T-SQL
- Oracle
Light Version Features
- Support SQL-DML ( select, insert, update, delete)
- Column selection/filter for select, insert and update
- Column alias name.
- Column default value.
- Conditional expression (WHERE)
- Column sorting (ORDER BY)
- Grouping (GROUP BY) and conditional (HAVING)
- Support any type of SQL joins (cross join, inner join, outer join)
- SQL join from one entity (table) to multiple entity (table)
- Support basic aggregate function (AVG, COUNT, MAX, MIN, and SUM)
- Support TOP for Select query (SqlClient only).
- Improve aggregation and grouping in select query.
- Add Irwsoft.Data.RelationAttribute to mark property in dataschema object as relation table.NEW !!!
Here are the Sample relation-table dataschema .
Professional Version Features :
- All features from Light version.
- T-SQL (Ms.Sql Server) :
- Support user defined stored function (scalar and table).
- Support user defined stored procedure.
- Implement analytic functions (RANK, DENSE_RANK, ROW_NUMBER and NTILE).
- Implement Over-Partition By on aggreagate function.NEW !!!
- PL/SQL (Oracle) :
- Support user defined stored function (scalar and table)
- Support user defined stored procedure
- Implement analytic functions (RANK, DENSE_RANK, ROW_NUMBER and NTILE).
- Implement Over-Partition By on aggreagate function.NEW !!!
- Implement Irwsoft.Data.OracleClient.OracleDualDataSchema to used as dataschema in common OracleSelectFrom query.NEW !!!
NOTE : Use OracleSelectFromDual for simple select [expression] from dual.
Ultimate Version Features :NEW !!!
- All features from Light and Professional version.
- Support insert query from table.
- Support execute relation table result in Irwsoft.Data.DataView that featured with local paging tool.
Download (Light Version)
Download (Profesional Version) NEW !!!
Donation
If you want to show your appreciation and support future development, you can make a donation to Irwsoft Framework.
Please visit my blog for suggestion, comment, and bugs :
|