public static Suffix GetSuffixBySFGCode(string sfgcode)
 {
     Suffix suffix = new Suffix();
     using (AHT_MainDataContext context = new AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString))
     {
         suffix = (from a in context.Suffixes
                     where a.sfgcode == sfgcode
                     select a).SingleOrDefault();
     }
     return suffix;
 }
        public static Suffix GetSuffixBySFGCode(string sfgcode)
        {
            Suffix suffix = new Suffix();

            using (AHT_MainDataContext context = new AHT_MainDataContext(ConfigurationManager.ConnectionStrings["AHT_MainConnectionString"].ConnectionString))
            {
                suffix = (from a in context.Suffixes
                          where a.sfgcode == sfgcode
                          select a).SingleOrDefault();
            }
            return(suffix);
        }
 partial void UpdateSuffix(Suffix instance);
 partial void DeleteSuffix(Suffix instance);
 partial void InsertSuffix(Suffix instance);