SQL Helper

What is SQL Helper?

I’m sharing this with the world because we need another way to access data – don’t you think? Truthfully – I wanted to see if I could flex the C# stuff and run up data access with a single dll and signle line of functions.

Features

• Fetch data with signle line of functions
• Fetch data with custome column’s name
• Fetch data with sorting
• Fetch data with diffrent type of joins
• Fetch data with paging
• SQL error handling
• Full dll source code – (You can customize as your own way)
• Development time saving…

Demo Code

• Select All Rows With All function

  dTable.All("TableName");

• Fetch data with Select function

  dTable.Select("TableName");
  dTable.Select("TableName", "Columns");
  dTable.Select("TableName", "Columns", "Where");
  dTable.Select("TableName", "Columns", "Sort", "SortType");
  dTable.Select("TableName", "Columns", "Where", "Sort", "SortType");
  

  Select function is very usefull and it has five overload methods. All parameters description is above this function.

• Fetch data with Where function

  dTable.Where("TableName", "Where");
  dTable.Where("TableName", "Where", "Columns");
  dTable.Where("TableName", "Where", "Columns", "Sort", "SortType");
  

• Fetch data with OrderBy function

  dTable.OrderBy("TableName", "Sort", "SortType");
  dTable.OrderBy("TableName", "Sort", "SortType", "Columns");
  dTable.OrderBy("TableName", "Sort", "SortType", "Columns", "Where");
  

• Fetch data with Paged function

  dTable.Paged("TableName", "PageIndex", "PageSize");
  dTable.Paged("TableName", "PageIndex", "PageSize", "Columns");
  dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "Where");
  dTable.Paged("TableName", "PageIndex", "PageSize", "Columns", , "Where", "Sort", "SortType");
  

  You can fetch data with paging and you paging result will return with MyResult class. PageIndex you require to pass your current page index. which you require to show in list. PageSize pass your current page size.

Support

Once again, As I said at the beginning, I’d be glad to help you if you have any questions relating to this code. I’ll do my best to assist. If you have a more general question relating to the code on CodeCanyon, you might contact me at here. Thanks so much!.

For new features:

Though we will never discourage users from developing solutions that solve their needs, the goals of the SQL Helper are very focused. If you are looking to get new features merged back into the SQL Helper DLL, we highly encourage you to contact me at ajmerainfo@gmail.com or write comment on my CodeCanyon this product page.

Thanks.