Hi,

I have a table that looks somehow like

I created a unique index over the ModuleID and Name fields, as this should be unique. Now I need two methods to get a single record, one by the ID field, the other by ModuleID and Name.

Info class:

   [TableName("MyTable")]
   [PrimaryKey("ID", AutoIncrement=true)]
   [Scope("ModuleID")]
   [Cacheable("MyTable", CacheItemPriority.Normal, 20)]
   public class MyInfo
   {
      public int ID { get; set; }
      public int ModuleID { get; set; }
      public string Name { get; set; }
      // etc.
   }

Controller class:

   public MyInfo Get(int id)
   {
      MyInfo something;
      using (IDataContext ctx = DataContext.Instance())
      {
         var rep = ctx.GetRepository();
         something = rep.GetById(id);
      }
      return something;
   }

As it is quite easy to retrieve a record by the method using the primary key, how can this be achieved for the second use case (ModuleID, Name)?

Happy DNNing!
Michael

You're welcome ! ;-)