Esempio n. 1
0
        internal static bool AlreadyHasServer(string servername)
        {
            var normalized = SQLDatabaseUsageClient.NormalizeServername(servername);

            return(DataContext.Do(ctx => {
                var db = ctx.SQLDatabases.FirstOrDefault(_ => _.Servername == normalized);
                return db != null;
            }));
        }
Esempio n. 2
0
 internal static void FinishSession(string sessionId)
 {
     DataContext.Do(ctx => {
         var session = ctx.AddSQLDatabaseSessions.Find(sessionId);
         ctx.SQLDatabases.Add(new SQLDatabase {
             Servername = SQLDatabaseUsageClient.NormalizeServername(session.Servername),
             Password   = session.Password,
             Username   = session.Username,
             Version    = GetVersionFromSession(session)
         });
         ctx.SaveChanges();
     });
 }
Esempio n. 3
0
        internal static SqlCredentials GetCredentials(string forServer)
        {
            return(DataContext.Do(ctx => {
                forServer = SQLDatabaseUsageClient.NormalizeServername(forServer);
                var record = ctx.SQLDatabases.FirstOrDefault(_ => _.Servername == forServer);
                if (record == null)
                {
                    throw new InvalidOperationException(string.Format("Couldn't fetch credentials for database server {0}", forServer));
                }

                return record.Credentials;
            }));
        }