Get all deleted record

subsonic

I'm looking for a way to get all records where deleted is set to true on a particular table. How might I accomplish this?

Note: Using auto-generated class by SubSonic. Not T-SQL.

Best Answer

The auto-generated SubSonic classes don't support querying logical deletes. But you can do this (version 2.1/2.2 syntax):

public partial class TableClassCollection
{

    public TableClassCollection LoadAll(bool suppressLogicalDeletes)
    {

          SubSonic.SqlQuery q = new SubSonic.Select(TableClass.Schema)
              .From(TableClass.Schema);

          if (suppressLogicalDeletes)
          {
              q.Where(TableClass.DeletedColumn).IsEqualTo(false);
          }

          return q.ExecuteAsCollection<TableClassCollection>();
      }

}

More examples at subsonicproject.com

Related Solutions

Delete all records from a table

The following will delete all rows from the TempTable which have an Id of greater than 56:

new Delete().From(TempTable.Schema)
  .Where(TempTable.Columns.Id).IsGreaterThan(56)
  .Execute();

Reengineer SQL into SubSonic LINQ

It sure seems like you could just add an alternative test to the where clause to do this.

var test = Menu.All()
               .Where(x => x.PageID == null
                       || x.WebPages
                           .Any(pages => pages.Roles.Contains(Roles.GetRolesForUser()[0])
                                            && pages.ID == x.PageID));

EDIT:

Try using the the Intersect method to see if there is an overlap between the roles in the DB and the roles for the user.

var test = Menu.All()
               .Where(x => x.PageID == null
                       || x.WebPages
                           .Any(pages => pages.Roles.Intersect(Roles.GetRolesForUser().Split(','))
                                            && pages.ID == x.PageID));

Best Answer

Related Solutions

Delete all records from a table

Reengineer SQL into SubSonic LINQ

Related Topic