DALC4NET (An All in One .NET Data Access Layer)

Https://drive.google.com/file/d/16f2mW1_XhdovoncAduZz6PRgouwPl0pj/view?usp=sharing hello please see the picture... I'm using tvp, (table value parameter ) what should I do for this? please give example code ? thank you

Hi , If i want to change from MS SQL to MySQL can i do that ?, if yes then how ? as MS SQL need "@" as prefix for parameter and MySQL does not ...

How can I pass datatable using this dll

Implementation of parent child relationship records handling is not provided in this project.

Boht aalaaa Ashish. Nice implementation !

Hello Ashish, can you please provide detailed steps to connect Oracle DB and retrieve the data. How about using Oracle.DataAccess.

Hi Ashish. Great article. I downloaded your component, and I must say it works quite well. I've used it in a couple of .NET and Sql Server projects, and haven't had a problem with it. Nevertheless, I'm trying to use it now on an Oracle database, but I've had some issues when executing a SP that returns one or more cursors (ref cursors in Oracle, actually). You see, when you use an OracleDataAdapter, you get to use an OracleDbType called Cursor, which is the type your out parameters should be, but in DbType you don't have an equivalent, so I haven't been able to succesfully execute any of those SPs I always get an ORA-06550 error, "wrong number or types of arguments in call to 'MY_SP'". How should I do this? Is you DAL actually capable of doing such thing? Thanks a lot.

very good one but we need to have key values for different provider .That means every time you upgrade oracle database the key value changes

Good one buddy.

Are there any different features as compared to Microsoft Database Application Block??

Thanks for sharing Ashish. It is useful.