public static void Initialize(MeetingContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Members.Any())
{
return; // DB has been seeded
}
Hymn[] hymns = DbInitializeHymns.InitializeHymns(context);
var members = new Member[]
{
new Member {
Salutation = Salutation.Elder, Name = "Tommy Knorr", isLeader = true
},
new Member {
Salutation = Salutation.President, Name = "Kevin Nielsen", isLeader = true
},
new Member {
Salutation = Salutation.Bishop, Name = "Kyle Johnson", isLeader = true
},
new Member {
Salutation = Salutation.Brother, Name = "Shayne Pierce", isLeader = true
},
new Member {
Salutation = Salutation.Brother, Name = "Parker Hall", isLeader = true
},
new Member {
Salutation = Salutation.Sister, Name = "Janis Maxwell"
},
new Member {
Salutation = Salutation.Brother, Name = "Greg Adams"
},
new Member {
Salutation = Salutation.Sister, Name = "Helen Black"
},
new Member {
Salutation = Salutation.Brother, Name = "Curtis Jones"
},
new Member {
Salutation = Salutation.Brother, Name = "Kelly Allmen"
},
new Member {
Salutation = Salutation.Sister, Name = "Sharon Cooper"
},
new Member {
Salutation = Salutation.Brother, Name = "Steve Jenson"
},
new Member {
Salutation = Salutation.Sister, Name = "Maggie Warner"
},
new Member {
Salutation = Salutation.Brother, Name = "Jeff Perkins"
},
new Member {
Salutation = Salutation.Sister, Name = "Stephanie Bronson"
},
new Member {
Salutation = Salutation.Brother, Name = "Glen Thomas"
},
new Member {
Salutation = Salutation.Brother, Name = "Mark Traver"
},
new Member {
Salutation = Salutation.Sister, Name = "Amy McDonald"
},
new Member {
Salutation = Salutation.Brother, Name = "Jason Marcus"
},
new Member {
Salutation = Salutation.Sister, Name = "Sheila Givens"
},
new Member {
Salutation = Salutation.Brother, Name = "Daniel Bell"
},
new Member {
Salutation = Salutation.Sister, Name = "Julie Johnson"
},
new Member {
Salutation = Salutation.Brother, Name = "Thomas Cane"
},
new Member {
Salutation = Salutation.Sister, Name = "Heidi Honaker"
},
new Member {
Salutation = Salutation.Brother, Name = "Gerald Donavan"
},
};
foreach (Member m in members)
{
context.Members.Add(m);
}
context.SaveChanges();
var AnnouncementQuotes = new string[]
{
"Reminder: no basketball this week.",
"Sunday School will start at 10:30 AM next week.",
"Baptism next Saturday at 3:00 PM at the stake center.",
"Tithing Settlement is coming up. Book your appointment.",
"Temple Prep class offered on Sundays at 4:00 PM at Brother Wayne's House.",
};
Ward w = new Ward {
Name = "Mount Pleasant First Ward"
};
context.Wards.Add(w);
//we have members, leaders, ward, hymns - time to make some meetings and assign some speakers
List <Meeting> meetings = new List <Meeting>();
DateTime startDate = DateTime.Now.Date;
startDate = startDate.AddDays(-49);
while (!startDate.DayOfWeek.Equals(DayOfWeek.Sunday))
{
startDate = startDate.AddDays(1);
}
//for (int i = 0; i < hymns.Length; i++)
//{
// System.Diagnostics.Debug.WriteLine(i.ToString() + " " + hymns[i].Number.ToString() + " " + hymns[i].Title);
//}
Random rand = new Random();
for (int i = 0; i < 10; i++)
{
Meeting meet = new Meeting();
meet.MeetingDate = startDate;
meet.FastAndTestimonyMeeting = (((i + 1) % 4) == 0);
meet.Ward = w;
meet.Presiding = members[rand.Next(3)];
meet.ConductingLeader = members[rand.Next(2, 5)];
meet.Chorister = members[rand.Next(3, members.Length)];
meet.Organist = members[rand.Next(3, members.Length)];
if (rand.Next(1, 2) == 1)
{
meet.Announcements = AnnouncementQuotes[rand.Next(AnnouncementQuotes.Length)];
}
meet.OpeningHymn = hymns[rand.Next(184)];
meet.OpeningPrayerMember = members[rand.Next(4, members.Length)];
meet.SacramentHymn = hymns[rand.Next(185, 212)];
if (i % 3 != 0)
{ //add optional rest hymn
if (!meet.FastAndTestimonyMeeting) //only add if not a fast Sunday
{
meet.OptionalRestHymnMember = members[rand.Next(4, members.Length)];
meet.OptionalRestHymnTitle = hymns[rand.Next(184)].Title;
}
}
meet.ClosingHymn = hymns[rand.Next(184)];
meet.ClosingPrayerMember = members[rand.Next(4, members.Length)];
meetings.Add(meet);
startDate = startDate.AddDays(7);
}
foreach (Meeting meet in meetings)
{
context.Meetings.Add(meet);
}
context.SaveChanges();
//now we have a bunch of meetings - need to add speakers
var topics = new string[]
{
"Atonement",
"Prophets",
"Tithing",
"Forgiveness",
"Holy Ghost",
"Covenants",
"Priesthood",
"Salvation",
"Gifts of the Spirit",
"Motherhood",
"Family Proclamation",
"Restoration",
"Baptism",
"Pioneers",
"Sacrifice",
"Virtue",
"Charity",
"Service",
"Repentance",
"Temple Ordinances",
"Missionary Service",
"Miracles",
"Book of Mormon",
"Word of Wisdom"
};
foreach (Meeting meet in meetings)
{
if (!meet.FastAndTestimonyMeeting)
{
//1 to 4 speakers
for (int i = 0; i < rand.Next(2, 6); i++)
{
Speaker s = new Speaker
{
Meeting = meet,
Member = members[rand.Next(members.Length)],
Topic = topics[rand.Next(topics.Length)],
Minutes = rand.Next(1, 6) * 3
};
context.Speakers.Add(s);
}
}
}
context.SaveChanges();
}
public static Hymn[] InitializeHymns(MeetingContext context)
{
var hymns = new Hymn[]
{
new Hymn {
Title = "The Morning Breaks", Number = 1
},
new Hymn {
Title = "The Spirit of God", Number = 2
},
new Hymn {
Title = "Now Let Us Rejoice", Number = 3
},
new Hymn {
Title = "Truth Eternal", Number = 4
},
new Hymn {
Title = "High on the Mountain Top", Number = 5
},
new Hymn {
Title = "Redeemer of Israel", Number = 6
},
new Hymn {
Title = "Israel, Israel, God Is Calling", Number = 7
},
new Hymn {
Title = "Awake and Arise", Number = 8
},
new Hymn {
Title = "Come, Rejoice", Number = 9
},
new Hymn {
Title = "Come, Sing to the Lord", Number = 10
},
new Hymn {
Title = "What Was Witnessed in the Heavens?", Number = 11
},
new Hymn {
Title = "'Twas Witnessed in the Morning Sky", Number = 12
},
new Hymn {
Title = "An Angel from on High", Number = 13
},
new Hymn {
Title = "Sweet Is the Peace the Gospel Brings", Number = 14
},
new Hymn {
Title = "I Saw a Mighty Angel Fly", Number = 15
},
new Hymn {
Title = "What Glorious Scenes Mine Eyes Behold", Number = 16
},
new Hymn {
Title = "Awake, Ye Saints of God, Awake!", Number = 17
},
new Hymn {
Title = "The Voice of God Again Is Heard", Number = 18
},
new Hymn {
Title = "We Thank Thee, O God, for a Prophet", Number = 19
},
new Hymn {
Title = "God of Power, God of Right", Number = 20
},
new Hymn {
Title = "Come, Listen to a Prophet's Voice", Number = 21
},
new Hymn {
Title = "We Listen to a Prophet's Voice", Number = 22
},
new Hymn {
Title = "We Ever Pray for Thee", Number = 23
},
new Hymn {
Title = "God Bless Our Prophet Dear", Number = 24
},
new Hymn {
Title = "Now We'll Sing with One Accord", Number = 25
},
new Hymn {
Title = "Joseph Smith's First Prayer", Number = 26
},
new Hymn {
Title = "Oh, how lovely was the morning", Number = 26
},
new Hymn {
Title = "Praise to the Man", Number = 27
},
new Hymn {
Title = "Saints, Behold How Great Jehovah", Number = 28
},
new Hymn {
Title = "A Poor Wayfaring Man of Grief", Number = 29
},
new Hymn {
Title = "Come, Come, Ye Saints", Number = 30
},
new Hymn {
Title = "O God, Our Help in Ages Past", Number = 31
},
new Hymn {
Title = "The Happy Day at Last Has Come", Number = 32
},
new Hymn {
Title = "Our Mountain Home So Dear", Number = 33
},
new Hymn {
Title = "O Ye Mountains High", Number = 34
},
new Hymn {
Title = "For the Strength of the Hills", Number = 35
},
new Hymn {
Title = "They, the Builders of the Nation", Number = 36
},
new Hymn {
Title = "The Wintry Day, Descending to Its Close", Number = 37
},
new Hymn {
Title = "Come, All Ye Saints of Zion", Number = 38
},
new Hymn {
Title = "O Saints of Zion", Number = 39
},
new Hymn {
Title = "Arise, O Glorious Zion", Number = 40
},
new Hymn {
Title = "Let Zion in Her Beauty Rise", Number = 41
},
new Hymn {
Title = "Hail to the Brightness of Zion's Glad Morning!", Number = 42
},
new Hymn {
Title = "Zion Stands with Hills Surrounded", Number = 43
},
new Hymn {
Title = "Beautiful Zion, Built Above", Number = 44
},
new Hymn {
Title = "Lead Me into Life Eternal", Number = 45
},
new Hymn {
Title = "Glorious Things of Thee Are Spoken", Number = 46
},
new Hymn {
Title = "We Will Sing of Zion", Number = 47
},
new Hymn {
Title = "Glorious Things Are Sung of Zion", Number = 48
},
new Hymn {
Title = "Adam-ondi-Ahman", Number = 49
},
new Hymn {
Title = "This earth was once a garden place", Number = 49
},
new Hymn {
Title = "Come, Thou Glorious Day of Promise", Number = 50
},
new Hymn {
Title = "Sons of Michael, He Approaches", Number = 51
},
new Hymn {
Title = "The Day Dawn Is Breaking", Number = 52
},
new Hymn {
Title = "Let Earth's Inhabitants Rejoice", Number = 53
},
new Hymn {
Title = "Behold, the Mountain of the Lord", Number = 54
},
new Hymn {
Title = "Lo, the Mighty God Appearing!", Number = 55
},
new Hymn {
Title = "Softly Beams the Sacred Dawning", Number = 56
},
new Hymn {
Title = "We're Not Ashamed to Own Our Lord", Number = 57
},
new Hymn {
Title = "Come, Ye Children of the Lord", Number = 58
},
new Hymn {
Title = "Come, O Thou King of Kings", Number = 59
},
new Hymn {
Title = "Battle Hymn of the Republic", Number = 60
},
new Hymn {
Title = "Mine eyes have seen the glory of the coming of the Lord", Number = 60
},
new Hymn {
Title = "Raise Your Voices to the Lord", Number = 61
},
new Hymn {
Title = "All Creatures of Our God and King", Number = 62
},
new Hymn {
Title = "Great King of Heaven", Number = 63
},
new Hymn {
Title = "On This Day of Joy and Gladness", Number = 64
},
new Hymn {
Title = "Come, All Ye Saints Who Dwell on Earth", Number = 65
},
new Hymn {
Title = "Rejoice, the Lord Is King!", Number = 66
},
new Hymn {
Title = "Glory to God on High", Number = 67
},
new Hymn {
Title = "A Mighty Fortress Is Our God", Number = 68
},
new Hymn {
Title = "All Glory, Laud, and Honor", Number = 69
},
new Hymn {
Title = "Sing Praise to Him", Number = 70
},
new Hymn {
Title = "With Songs of Praise", Number = 71
},
new Hymn {
Title = "Praise to the Lord, the Almighty", Number = 72
},
new Hymn {
Title = "Praise the Lord with Heart and Voice", Number = 73
},
new Hymn {
Title = "Praise Ye the Lord", Number = 74
},
new Hymn {
Title = "In Hymns of Praise", Number = 75
},
new Hymn {
Title = "God of Our Fathers, We Come unto Thee", Number = 76
},
new Hymn {
Title = "Great Is the Lord", Number = 77
},
new Hymn {
Title = "God of Our Fathers, Whose Almighty Hand", Number = 78
},
new Hymn {
Title = "With All the Power of Heart and Tongue", Number = 79
},
new Hymn {
Title = "God of Our Fathers, Known of Old", Number = 80
},
new Hymn {
Title = "Press Forward, Saints", Number = 81
},
new Hymn {
Title = "For All the Saints", Number = 82
},
new Hymn {
Title = "Guide Us, O Thou Great Jehovah", Number = 83
},
new Hymn {
Title = "Faith of Our Fathers", Number = 84
},
new Hymn {
Title = "How Firm a Foundation", Number = 85
},
new Hymn {
Title = "How Great Thou Art", Number = 86
},
new Hymn {
Title = "Earth, with her ten thousand flow'rs", Number = 87
},
new Hymn {
Title = "God Is Love", Number = 87
},
new Hymn {
Title = "Great God, Attend While Zion Sings", Number = 88
},
new Hymn {
Title = "The Lord Is My Light", Number = 89
},
new Hymn {
Title = "From All That Dwell below the Skies", Number = 90
},
new Hymn {
Title = "Father, Thy Children to Thee Now Raise", Number = 91
},
new Hymn {
Title = "For the Beauty of the Earth", Number = 92
},
new Hymn {
Title = "Prayer of Thanksgiving", Number = 93
},
new Hymn {
Title = "We gather together to ask the Lord's blessing", Number = 93
},
new Hymn {
Title = "Come, Ye Thankful People", Number = 94
},
new Hymn {
Title = "Now Thank We All Our God", Number = 95
},
new Hymn {
Title = "Dearest Children, God Is Near You", Number = 96
},
new Hymn {
Title = "Lead, Kindly Light", Number = 97
},
new Hymn {
Title = "I Need Thee Every Hour", Number = 98
},
new Hymn {
Title = "Nearer, Dear Savior, to Thee", Number = 99
},
new Hymn {
Title = "Nearer, My God, to Thee", Number = 100
},
new Hymn {
Title = "Guide Me to Thee", Number = 101
},
new Hymn {
Title = "Jesus, my Savior true", Number = 101
},
new Hymn {
Title = "Jesus, Lover of My Soul", Number = 102
},
new Hymn {
Title = "Precious Savior, Dear Redeemer", Number = 103
},
new Hymn {
Title = "Jesus, Savior, Pilot Me", Number = 104
},
new Hymn {
Title = "Master, the Tempest Is Raging", Number = 105
},
new Hymn {
Title = "God Speed the Right", Number = 106
},
new Hymn {
Title = "Now to heav'n our prayer ascending", Number = 106
},
new Hymn {
Title = "Lord, Accept Our True Devotion", Number = 107
},
new Hymn {
Title = "The Lord Is My Shepherd", Number = 108
},
new Hymn {
Title = "The Lord My Pasture Will Prepare", Number = 109
},
new Hymn {
Title = "Cast Thy Burden upon the Lord", Number = 110
},
new Hymn {
Title = "Rock of Ages", Number = 111
},
new Hymn {
Title = "Savior, Redeemer of My Soul", Number = 112
},
new Hymn {
Title = "Our Savior's Love", Number = 113
},
new Hymn {
Title = "Come unto Him", Number = 114
},
new Hymn {
Title = "I wander through the still of night", Number = 114
},
new Hymn {
Title = "Come, Ye Disconsolate", Number = 115
},
new Hymn {
Title = "Come, Follow Me", Number = 116
},
new Hymn {
Title = "Come unto Jesus", Number = 117
},
new Hymn {
Title = "Ye Simple Souls Who Stray", Number = 118
},
new Hymn {
Title = "Come, We That Love the Lord", Number = 119
},
new Hymn {
Title = "Lean on My Ample Arm", Number = 120
},
new Hymn {
Title = "I'm a Pilgrim, I'm a Stranger", Number = 121
},
new Hymn {
Title = "Though Deepening Trials", Number = 122
},
new Hymn {
Title = "Oh, May My Soul Commune with Thee", Number = 123
},
new Hymn {
Title = "Be Still, My Soul", Number = 124
},
new Hymn {
Title = "How Gentle God's Commands", Number = 125
},
new Hymn {
Title = "How Long, O Lord Most Holy and True", Number = 126
},
new Hymn {
Title = "Does the Journey Seem Long?", Number = 127
},
new Hymn {
Title = "I will not doubt, I will not fear", Number = 128
},
new Hymn {
Title = "When Faith Endures", Number = 128
},
new Hymn {
Title = "Where Can I Turn for Peace?", Number = 129
},
new Hymn {
Title = "Be Thou Humble", Number = 130
},
new Hymn {
Title = "More Holiness Give Me", Number = 131
},
new Hymn {
Title = "God Is in His Holy Temple", Number = 132
},
new Hymn {
Title = "Father in Heaven", Number = 133
},
new Hymn {
Title = "I Believe in Christ", Number = 134
},
new Hymn {
Title = "I know that my Redeemer lives", Number = 135
},
new Hymn {
Title = "My Redeemer Lives", Number = 135
},
new Hymn {
Title = "I Know That My Redeemer Lives", Number = 136
},
new Hymn {
Title = "Testimony", Number = 137
},
new Hymn {
Title = "Bless Our Fast, We Pray", Number = 138
},
new Hymn {
Title = "On bended knees, with broken hearts", Number = 138
},
new Hymn {
Title = "In Fasting We Approach Thee", Number = 139
},
new Hymn {
Title = "Did You Think to Pray?", Number = 140
},
new Hymn {
Title = "Ere you left your room this morning", Number = 140
},
new Hymn {
Title = "Jesus, the Very Thought of Thee", Number = 141
},
new Hymn {
Title = "Sweet Hour of Prayer", Number = 142
},
new Hymn {
Title = "Let the Holy Spirit Guide", Number = 143
},
new Hymn {
Title = "Secret Prayer", Number = 144
},
new Hymn {
Title = "There is an hour of peace and rest", Number = 144
},
new Hymn {
Title = "Prayer Is the Soul's Sincere Desire", Number = 145
},
new Hymn {
Title = "Gently Raise the Sacred Strain", Number = 146
},
new Hymn {
Title = "Sweet Is the Work", Number = 147
},
new Hymn {
Title = "In sweet remembrance of thy Son", Number = 148
},
new Hymn {
Title = "Sabbath Day", Number = 148
},
new Hymn {
Title = "As the Dew from Heaven Distilling", Number = 149
},
new Hymn {
Title = "O Thou Kind and Gracious Father", Number = 150
},
new Hymn {
Title = "We Meet, Dear Lord", Number = 151
},
new Hymn {
Title = "God Be with You Till We Meet Again", Number = 152
},
new Hymn {
Title = "Lord, We Ask Thee Ere We Part", Number = 153
},
new Hymn {
Title = "Father, This Hour Has Been One of Joy", Number = 154
},
new Hymn {
Title = "We Have Partaken of Thy Love", Number = 155
},
new Hymn {
Title = "Sing We Now at Parting", Number = 156
},
new Hymn {
Title = "Thy Spirit, Lord, Has Stirred Our Souls", Number = 157
},
new Hymn {
Title = "Before Thee, Lord, I Bow My Head", Number = 158
},
new Hymn {
Title = "Now the Day Is Over", Number = 159
},
new Hymn {
Title = "Softly Now the Light of Day", Number = 160
},
new Hymn {
Title = "The Lord Be with Us", Number = 161
},
new Hymn {
Title = "Lord, We Come before Thee Now", Number = 162
},
new Hymn {
Title = "Lord, Dismiss Us with Thy Blessing", Number = 163
},
new Hymn {
Title = "Great God, to Thee My Evening Song", Number = 164
},
new Hymn {
Title = "Abide with Me; 'Tis Eventide", Number = 165
},
new Hymn {
Title = "Abide with Me!", Number = 166
},
new Hymn {
Title = "Come, Let Us Sing an Evening Hymn", Number = 167
},
new Hymn {
Title = "As the Shadows Fall", Number = 168
},
new Hymn {
Title = "As Now We Take the Sacrament", Number = 169
},
new Hymn {
Title = "God, Our Father, Hear Us Pray", Number = 170
},
new Hymn {
Title = "With Humble Heart", Number = 171
},
new Hymn {
Title = "In Humility, Our Savior", Number = 172
},
new Hymn {
Title = "While of These Emblems We Partake", Number = 173
},
new Hymn {
Title = "While of These Emblems We Partake", Number = 174
},
new Hymn {
Title = "O God, the Eternal Father", Number = 175
},
new Hymn {
Title = "'Tis Sweet to Sing the Matchless Love", Number = 176
},
new Hymn {
Title = "'Tis Sweet To Sing the Matchless Love", Number = 177
},
new Hymn {
Title = "O Lord of Hosts", Number = 178
},
new Hymn {
Title = "Again, Our Dear Redeeming Lord", Number = 179
},
new Hymn {
Title = "Father in Heaven, We Do Believe", Number = 180
},
new Hymn {
Title = "Jesus of Nazareth, Savior and King", Number = 181
},
new Hymn {
Title = "We'll Sing All Hail to Jesus' Name", Number = 182
},
new Hymn {
Title = "In Remembrance of Thy Suffering", Number = 183
},
new Hymn {
Title = "Upon the Cross of Calvary", Number = 184
},
new Hymn {
Title = "Reverently and Meekly Now", Number = 185
},
new Hymn {
Title = "Again We Meet around the Board", Number = 186
},
new Hymn {
Title = "God Loved Us, So He Sent His Son", Number = 187
},
new Hymn {
Title = "Thy Will, O Lord, Be Done", Number = 188
},
new Hymn {
Title = "When in the wondrous realms above", Number = 188
},
new Hymn {
Title = "O Thou, Before the World Began", Number = 189
},
new Hymn {
Title = "In Memory of the Crucified", Number = 190
},
new Hymn {
Title = "Behold the Great Redeemer Die", Number = 191
},
new Hymn {
Title = "He Died! The Great Redeemer Died", Number = 192
},
new Hymn {
Title = "I Stand All Amazed", Number = 193
},
new Hymn {
Title = "There Is a Green Hill Far Away", Number = 194
},
new Hymn {
Title = "How Great the Wisdom and the Love", Number = 195
},
new Hymn {
Title = "Jesus, Once of Humble Birth", Number = 196
},
new Hymn {
Title = "O Savior, Thou Who Wearest a Crown", Number = 197
},
new Hymn {
Title = "That Easter Morn", Number = 198
},
new Hymn {
Title = "He Is Risen!", Number = 199
},
new Hymn {
Title = "Christ the Lord Is Risen Today", Number = 200
},
new Hymn {
Title = "Joy to the World", Number = 201
},
new Hymn {
Title = "Oh, Come, All Ye Faithful", Number = 202
},
new Hymn {
Title = "Angels We Have Heard on High", Number = 203
},
new Hymn {
Title = "Silent Night", Number = 204
},
new Hymn {
Title = "Once in Royal David's City", Number = 205
},
new Hymn {
Title = "Away in a Manger", Number = 206
},
new Hymn {
Title = "It Came upon the Midnight Clear", Number = 207
},
new Hymn {
Title = "O Little Town of Bethlehem", Number = 208
},
new Hymn {
Title = "Hark! The Herald Angels Sing", Number = 209
},
new Hymn {
Title = "With Wondering Awe", Number = 210
},
new Hymn {
Title = "While Shepherds Watched Their Flocks", Number = 211
},
new Hymn {
Title = "Far, Far Away on Judea's Plains", Number = 212
},
new Hymn {
Title = "The First Noel", Number = 213
},
new Hymn {
Title = "I Heard the Bells on Christmas Day", Number = 214
},
new Hymn {
Title = "Ring Out, Wild Bells", Number = 215
},
new Hymn {
Title = "We Are Sowing", Number = 216
},
new Hymn {
Title = "Come, Let Us Anew", Number = 217
},
new Hymn {
Title = "We Give Thee But Thine Own", Number = 218
},
new Hymn {
Title = "Because I Have Been Given Much", Number = 219
},
new Hymn {
Title = "Lord, I Would Follow Thee", Number = 220
},
new Hymn {
Title = "Savior, may I learn to love thee", Number = 220
},
new Hymn {
Title = "Dear to the Heart of the Shepherd", Number = 221
},
new Hymn {
Title = "Hear Thou Our Hymn, O Lord", Number = 222
},
new Hymn {
Title = "Have I Done Any Good?", Number = 223
},
new Hymn {
Title = "I Have Work Enough to Do", Number = 224
},
new Hymn {
Title = "We Are Marching On to Glory", Number = 225
},
new Hymn {
Title = "Improve the Shining Moments", Number = 226
},
new Hymn {
Title = "There Is Sunshine in My Soul Today", Number = 227
},
new Hymn {
Title = "You Can Make the Pathway Bright", Number = 228
},
new Hymn {
Title = "Today, While the Sun Shines", Number = 229
},
new Hymn {
Title = "In a world where sorrow", Number = 230
},
new Hymn {
Title = "Scatter Sunshine", Number = 230
},
new Hymn {
Title = "Father, Cheer Our Souls Tonight", Number = 231
},
new Hymn {
Title = "Let Us Oft Speak Kind Words", Number = 232
},
new Hymn {
Title = "Nay, Speak No Ill", Number = 233
},
new Hymn {
Title = "Jesus, Mighty King in Zion", Number = 234
},
new Hymn {
Title = "Should You Feel Inclined to Censure", Number = 235
},
new Hymn {
Title = "Lord, Accept into Thy Kingdom", Number = 236
},
new Hymn {
Title = "Do What Is Right", Number = 237
},
new Hymn {
Title = "Behold Thy Sons and Daughters, Lord", Number = 238
},
new Hymn {
Title = "Choose the Right", Number = 239
},
new Hymn {
Title = "Know This, That Every Soul Is Free", Number = 240
},
new Hymn {
Title = "Count Your Blessings", Number = 241
},
new Hymn {
Title = "When upon life's billows you are tempest-tossed", Number = 241
},
new Hymn {
Title = "Praise God, from Whom All Blessings Flow", Number = 242
},
new Hymn {
Title = "Let Us All Press On", Number = 243
},
new Hymn {
Title = "Come Along, Come Along", Number = 244
},
new Hymn {
Title = "This House We Dedicate to Thee", Number = 245
},
new Hymn {
Title = "Onward, Christian Soldiers", Number = 246
},
new Hymn {
Title = "We Love Thy House, O God", Number = 247
},
new Hymn {
Title = "Up, Awake, Ye Defenders of Zion", Number = 248
},
new Hymn {
Title = "Called to Serve", Number = 249
},
new Hymn {
Title = "We Are All Enlisted", Number = 250
},
new Hymn {
Title = "Behold! A Royal Army", Number = 251
},
new Hymn {
Title = "Put Your Shoulder to the Wheel", Number = 252
},
new Hymn {
Title = "The world has need of willing men", Number = 252
},
new Hymn {
Title = "Like Ten Thousand Legions Marching", Number = 253
},
new Hymn {
Title = "Shall the youth of Zion falter", Number = 254
},
new Hymn {
Title = "True to the Faith", Number = 254
},
new Hymn {
Title = "Carry On", Number = 255
},
new Hymn {
Title = "Firm as the mountains around us", Number = 255
},
new Hymn {
Title = "As Zion's Youth in Latter Days", Number = 256
},
new Hymn {
Title = "Rejoice! A Glorious Sound Is Heard", Number = 257
},
new Hymn {
Title = "O Thou Rock of Our Salvation", Number = 258
},
new Hymn {
Title = "Hope of Israel", Number = 259
},
new Hymn {
Title = "Who's on the Lord's Side?", Number = 260
},
new Hymn {
Title = "Thy Servants Are Prepared", Number = 261
},
new Hymn {
Title = "Go, Ye Messengers of Glory", Number = 262
},
new Hymn {
Title = "Go Forth with Faith", Number = 263
},
new Hymn {
Title = "Hark, All Ye Nations!", Number = 264
},
new Hymn {
Title = "Arise, O God, and Shine", Number = 265
},
new Hymn {
Title = "The Time Is Far Spent", Number = 266
},
new Hymn {
Title = "How Wondrous and Great", Number = 267
},
new Hymn {
Title = "Come, All Whose Souls Are Lighted", Number = 268
},
new Hymn {
Title = "Jehovah, Lord of Heaven and Earth", Number = 269
},
new Hymn {
Title = "I'll Go Where You Want Me to Go", Number = 270
},
new Hymn {
Title = "Oh, Holy Words of Truth and Love", Number = 271
},
new Hymn {
Title = "Oh Say, What Is Truth?", Number = 272
},
new Hymn {
Title = "Truth Reflects upon Our Senses", Number = 273
},
new Hymn {
Title = "The Iron Rod", Number = 274
},
new Hymn {
Title = "A voice hath spoken from the dust", Number = 275
},
new Hymn {
Title = "Men Are That They Might Have Joy", Number = 275
},
new Hymn {
Title = "Come Away to the Sunday School", Number = 276
},
new Hymn {
Title = "When the rosy light of morning", Number = 276
},
new Hymn {
Title = "As I Search the Holy Scriptures", Number = 277
},
new Hymn {
Title = "Thanks for the Sabbath School", Number = 278
},
new Hymn {
Title = "Thy Holy Word", Number = 279
},
new Hymn {
Title = "We love to hear thy holy word", Number = 279
},
new Hymn {
Title = "Welcome, Welcome, Sabbath Morning", Number = 280
},
new Hymn {
Title = "Help Me Teach with Inspiration", Number = 281
},
new Hymn {
Title = "We Meet Again in Sabbath School", Number = 282
},
new Hymn {
Title = "The Glorious Gospel Light Has Shone", Number = 283
},
new Hymn {
Title = "If You Could Hie to Kolob", Number = 284
},
new Hymn {
Title = "God Moves in a Mysterious Way", Number = 285
},
new Hymn {
Title = "Oh, What Songs of the Heart", Number = 286
},
new Hymn {
Title = "Rise, Ye Saints, and Temples Enter", Number = 287
},
new Hymn {
Title = "How Beautiful Thy Temples, Lord", Number = 288
},
new Hymn {
Title = "Holy Temples on Mount Zion", Number = 289
},
new Hymn {
Title = "Rejoice, Ye Saints of Latter Days", Number = 290
},
new Hymn {
Title = "Turn Your Hearts", Number = 291
},
new Hymn {
Title = "O My Father", Number = 292
},
new Hymn {
Title = "Each Life That Touches Ours for Good", Number = 293
},
new Hymn {
Title = "Love at Home", Number = 294
},
new Hymn {
Title = "There is beauty all around", Number = 294
},
new Hymn {
Title = "O Love That Glorifies the Son", Number = 295
},
new Hymn {
Title = "Our Father, by Whose Name", Number = 296
},
new Hymn {
Title = "From Homes of Saints Glad Songs Arise", Number = 297
},
new Hymn {
Title = "Home Can Be a Heaven on Earth", Number = 298
},
new Hymn {
Title = "Children of Our Heavenly Father", Number = 299
},
new Hymn {
Title = "Families Can Be Together Forever", Number = 300
},
new Hymn {
Title = "I have a fam'ly here on earth.", Number = 300
},
new Hymn {
Title = "I Am a Child of God", Number = 301
},
new Hymn {
Title = "I Know My Father Lives", Number = 302
},
new Hymn {
Title = "Keep the Commandments", Number = 303
},
new Hymn {
Title = "Teach Me to Walk in the Light", Number = 304
},
new Hymn {
Title = "The Light Divine", Number = 305
},
new Hymn {
Title = "As I watch the rising sun", Number = 306
},
new Hymn {
Title = "God's Daily Care", Number = 306
},
new Hymn {
Title = "In Our Lovely Deseret", Number = 307
},
new Hymn {
Title = "As I have loved you", Number = 308
},
new Hymn {
Title = "Love One Another", Number = 308
},
new Hymn {
Title = "As Sisters in Zion (Women)", Number = 309
},
new Hymn {
Title = "A Key Was Turned in Latter Days (Women)", Number = 310
},
new Hymn {
Title = "We Meet Again as Sisters (Women)", Number = 311
},
new Hymn {
Title = "We Ever Pray for Thee (Women)", Number = 312
},
new Hymn {
Title = "Earth, with her ten thousand flow'rs (women)", Number = 313
},
new Hymn {
Title = "God Is Love (Women)", Number = 313
},
new Hymn {
Title = "How Gentle God's Commands (Women)", Number = 314
},
new Hymn {
Title = "Jesus, the Very Thought of Thee (Women)", Number = 315
},
new Hymn {
Title = "The Lord Is My Shepherd (Women)", Number = 316
},
new Hymn {
Title = "Sweet Is the Work (Women)", Number = 317
},
new Hymn {
Title = "Love at Home (Women)", Number = 318
},
new Hymn {
Title = "There is beauty all around (women)", Number = 318
},
new Hymn {
Title = "Ye Elders of Israel (Men)", Number = 319
},
new Hymn {
Title = "Brethren, pow'r by earthly standards", Number = 320
},
new Hymn {
Title = "The Priesthood of Our Lord (Men)", Number = 320
},
new Hymn {
Title = "Ye Who Are Called to Labor (Men)", Number = 321
},
new Hymn {
Title = "Come, All Ye Sons of God (Men)", Number = 322
},
new Hymn {
Title = "Rise Up, O Men of God (Men's Choir)", Number = 323
},
new Hymn {
Title = "Rise Up, O Men of God (Men)", Number = 324
},
new Hymn {
Title = "See the Mighty Priesthood Gathered (Men's Choir)", Number = 325
},
new Hymn {
Title = "Come, Come, Ye Saints (Men's Choir)", Number = 326
},
new Hymn {
Title = "Go, Ye Messengers of Heaven (Men's Choir)", Number = 327
},
new Hymn {
Title = "An Angel from on High", Number = 328
},
new Hymn {
Title = "Thy Servants Are Prepared (Men's Choir)", Number = 329
},
new Hymn {
Title = "See, the Mighty Angel Flying (Men's Choir)", Number = 330
},
new Hymn {
Title = "Oh Say, What Is Truth? (Men's Choir)", Number = 331
},
new Hymn {
Title = "Come, O Thou King of Kings (Men's Choir)", Number = 332
},
new Hymn {
Title = "High on the Mountain Top (Men's Choir)", Number = 333
},
new Hymn {
Title = "I Need Thee Every Hour (Men's Choir)", Number = 334
},
new Hymn {
Title = "Brightly Beams Our Father's Mercy (Men's Choir)", Number = 335
},
new Hymn {
Title = "School Thy Feelings (Men's Choir)", Number = 336
},
new Hymn {
Title = "O Home Beloved (Men's Choir)", Number = 337
},
new Hymn {
Title = "America the Beautiful", Number = 338
},
new Hymn {
Title = "Oh, beautiful for spacious skies", Number = 338
},
new Hymn {
Title = "My Country, 'Tis of Thee", Number = 339
},
new Hymn {
Title = "Oh say, can you see, by the dawn's early light", Number = 340
},
new Hymn {
Title = "The Star-Spangled Banner", Number = 340
},
new Hymn {
Title = "God Save the King", Number = 341
},
};
foreach (Hymn h in hymns)
{
context.Hymns.Add(h);
}
context.SaveChanges();
return(hymns);
}
