public CampaignRepositorySql()
        {
            string selCampaigns = "select * from CampaignStates";
            string selPlayers = "select * from Player";
            string cs = ConfigurationManager.ConnectionStrings["GcmlDbContext"].ConnectionString;
            conn = new SqlCeConnection(cs);

            daCampaignStates = new SqlCeDataAdapter(selCampaigns, conn);
            daPlayers = new SqlCeDataAdapter(selPlayers, conn);

            SqlCeCommandBuilder cpcampaigns = new SqlCeCommandBuilder(daCampaignStates);
            SqlCeCommandBuilder cpplayers = new SqlCeCommandBuilder(daPlayers);

            ds = new GcmlData();
            daCampaignStates.Fill(ds.CampaignStates);
            daPlayers.Fill(ds.Player);
        }
 private CampaignController getControllerFromStateRow(GcmlData.CampaignStatesRow stateRow)
 {
     CampaignController result;
     string statedata = stateRow.CampaignData;
     CampaignState state = CampaignState.FromString(statedata);
     CampaignEngine engine = CampaignEngine.restoreFromState(state);
     result = new CampaignController(engine);
     return result;
 }