Filtering/Ordering Results

Back to Examples

When using the ToDataTable(), ToIEnumerable(), or ToList() methods for any View/Table Model you may have, the option of specifying additional clauses is available in MagnaDB. Just make sure to specify those additional clauses as arguments for any in these functions or their overloads.

Make sure you use the following parameters the way they're intended to:

• extraConditions: this is a format string (similar to how Console.WriteLine or string.Format work, you may specify parameters numerically order in it) in which you specify SQL clauses that will be placed after the internally generated SELECT command for any of the aforementioned methods.
  In order to filter/order/paginate/etc., or other functionalities you may want, you can specify the SQL clauses that'll give you the desired output (WHERE or ORDER BY clauses for example).
  Since this parameter adds to the already generated SELECT statement, you shouldn't (by any means possible) include clauses that would need to alter the columns structure in order to work (for example, you shouldn't use GROUP BY or PIVOT clauses).
  
• values: specify any number of arguments that you wish to format into the resulting string. Keep in mind, this is done in order for MagnaDB to handle that the resulting SQL commands are injection-free.
  

using System;

namespace TestMagnaDB
{
    class Program
    {
        static void Main(string[] args)
        {
            const string Longhair = "Longhair";
            
            // Here's an example on how to order/filter results.
            // Let's say we have our Cat class (Home Page, Table Models section)
            // and we wanted only the kittens that were Longhair and we wanted
            // them ordered by name. The next line of code accomplishes that.
            var longhairKittensByName = Cat.ToList("WHERE Breed='{0}' ORDER BY Name", Longhair);
        }
    }
}