public static int CreateGameWithGameConfigurationEntry(string connectionString) { var idSelect = new SqlSelectStatement(connectionString); idSelect.Top(1) .Select("G.Id") .From("dbo.BZ_Game", "G") .Join("dbo.BZ_Game_Configuration", "GC", "GC.GameId = G.Id"); var id = idSelect.ExecuteScalar<int?>(); if (!id.HasValue) { var name = Utilities.GetRandomString(16); var gameInsert = new SqlInsertStatement(connectionString); gameInsert.InsertInto("dbo.BZ_Game") .Column("CreatedBy", 1) .Column("CreatedDate", DateTime.Now) .Column("Name") .Column("IndustryId", 1) .Values() .Value("Name", name); gameInsert.Execute(); idSelect = new SqlSelectStatement(connectionString); idSelect.Top(1) .Select("Id") .From("dbo.BZ_Game") .WhereEquals("Name", name); id = idSelect.ExecuteScalar<int?>(); var entryInsert = new SqlInsertStatement(connectionString); entryInsert.InsertInto("dbo.BZ_Game_Configuration") .Column("GameId", id.Value) .Column("ConfigurationKeyId", 1) .Column("Value") .Values() .Value("Value", "Test Value"); entryInsert.Execute(); } return id.Value; }
public static int GetGameId(string connectionString, string name) { var sql = new SqlInsertStatement(connectionString); sql.InsertInto("dbo.BZ_Game") .Column("CreatedBy", 1) .Column("CreatedDate", DateTime.Now) .Column("Name") .Column("IndustryId", 1) .Values() .Value("Name", name); sql.Execute(); var select = new SqlSelectStatement(connectionString); select.Top(1) .From("dbo.BZ_Game") .Select("Id") .WhereEquals("Name", name); return select.ExecuteScalar<int>(); }