Linq to SQL, Generic Reposity Classes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mihai Popescu
    New Member
    • Jul 2010
    • 4

    Linq to SQL, Generic Reposity Classes

    hi, i have the next code:
    Code:
        public class ActivationDataRepository
        {   
            private string strConnString;
            private PEGdbDataContext db;
    
            public ActivationDataRepository(string xmlPath)
            {
    this.strConnString ConfigurationManager.ConnectionStrings["pecConnectionString"].ConnectionString;
            this.db = new PEGdbDataContext(strConnString, XmlMappingSource.FromUrl(xmlPath));}
            
    public IQueryable<ActivationData> FindAllData()
            { return db.GetTable<ActivationData>();}
            
    public ActivationData GetActivationData(string id)
            {return db.GetTable<ActivationData>().SingleOrDefault(d => d.Id == id);}
            
    public void Add(ActivationData activationData)
            {db.GetTable<ActivationData>().InsertOnSubmit(activationData);}
            
    public void Delete(ActivationData activationData)
            { db.GetTable<ActivationData>().DeleteOnSubmit(activationData); }
        }
    Can someone help me to create a generic class from this one, to be able to create other type objects?
Working...