C# (CSharp) SYMData Examples

Example #1

File: DataAccess.cs Project: ashwnacharya/speakout

        public static void RemoveTwitterAccount(string accountName)
        {
            SYMData db = new SYMData(ConfigurationHelper.Instance.DBConnectionString);

            TwitterAccounts toDelete = db.TwitterAccounts.Single(account => account.AccountName == accountName);
            db.TwitterAccounts.DeleteOnSubmit(toDelete);
            db.SubmitChanges();
        }

Example #2

        public static void RemoveTwitterAccount(string accountName)
        {
            SYMData db = new SYMData(ConfigurationHelper.Instance.DBConnectionString);

            TwitterAccounts toDelete = db.TwitterAccounts.Single(account => account.AccountName == accountName);

            db.TwitterAccounts.DeleteOnSubmit(toDelete);
            db.SubmitChanges();
        }

Example #3

File: DataAccess.cs Project: ashwnacharya/speakout

        public static IQueryable<TwitterAccounts> GetTwitterAccounts()
        {
            SYMData db = new SYMData(ConfigurationHelper.Instance.DBConnectionString);

            var objAccounts = from objAccount in db.TwitterAccounts
                        select objAccount;

            return objAccounts;
        }

Example #4

        public static IQueryable <TwitterAccounts> GetTwitterAccounts()
        {
            SYMData db = new SYMData(ConfigurationHelper.Instance.DBConnectionString);

            var objAccounts = from objAccount in db.TwitterAccounts
                              select objAccount;



            return(objAccounts);
        }

Example #5

File: DataAccess.cs Project: ashwnacharya/speakout

        public static void AddTwitterAccount(string accountName, string accessTokenString, string verificationString)
        {
            SYMData db = new SYMData(ConfigurationHelper.Instance.DBConnectionString);
            TwitterAccounts account = new TwitterAccounts();
            account.AccountName = accountName;
            account.AccessToken = accessTokenString;
            account.VerificationString = verificationString;

            db.TwitterAccounts.InsertOnSubmit(account);
            db.SubmitChanges();
        }

Example #6

        public static void AddTwitterAccount(string accountName, string accessTokenString, string verificationString)
        {
            SYMData         db      = new SYMData(ConfigurationHelper.Instance.DBConnectionString);
            TwitterAccounts account = new TwitterAccounts();

            account.AccountName        = accountName;
            account.AccessToken        = accessTokenString;
            account.VerificationString = verificationString;

            db.TwitterAccounts.InsertOnSubmit(account);
            db.SubmitChanges();
        }