Using Microsoft.Data.SqlClient (.NET 4.8 Framework) with ASP.NET Core
This API uses a C# abstract class I developed to query a couple of Microsoft SQL Server database tables. The 'Bible' table contains 3,116,480 letters in 783,137 words in 31,103 rows of data. There are 12,593 unique words, including proper names in the Bible.
Results are returned in standard JSON format.
API Reference:
- GetBookList - Returns the complete list of Books in The Holy Bible (King James Version) (as displayed on this page)
- GetBook - Returns all the text of a single Book (i.e. {book number} for Genesis is '1', Exodus is '2', etc.)
- GetChapter - Returns all Verses within a Chapter of a Book (i.e. {book number} as above plus a {chapter number})
- GetVerse - Returns a single Verse ({book number}, {chapter number} are same as above with an included {verse number})
- Search - Returns any Book(s), Chapter(s) and Verse(s) that contain the {search text}, which may contain any word(s) or a partial word
Books of The Holy Bible (King James Version)
Clicking on any of the Books will open a new tab with a JSON result containing all of the Chapters and Verses of that Book.
# | Book | Title | Chapters | Verses |
---|---|---|---|---|
1 | Genesis | The First Book of Moses, called Genesis | 50 | 1533 |
2 | Exodus | The Second Book of Moses, called Exodus | 40 | 1213 |
3 | Leviticus | The Third Book of Moses, called Leviticus | 27 | 859 |
4 | Numbers | The Fourth Book of Moses, called Numbers | 36 | 1288 |
5 | Deuteronomy | The Fifth Book of Moses, called Deuteronomy | 34 | 959 |
6 | Joshua | The Book of Joshua | 24 | 658 |
7 | Judges | The Book of Judges | 21 | 618 |
8 | Ruth | The Book of Ruth | 4 | 85 |
9 | 1 Samuel | The First Book of Samuel, otherwise called the First Book of the Kings | 31 | 810 |
10 | 2 Samuel | The Second Book of Samuel, otherwise called the Second Book of the Kings | 24 | 695 |
11 | 1 Kings | The First Book of the Kings, commonly called the Third Book of the Kings | 22 | 816 |
12 | 2 Kings | The Second Book of the Kings, commonly called the Fourth Book of the Kings | 25 | 719 |
13 | 1 Chronicles | The First Book of the Chronicles | 29 | 942 |
14 | 2 Chronicles | The Second Book of the Chronicles | 36 | 822 |
15 | Ezra | Ezra | 10 | 280 |
16 | Nehemiah | The Book of Nehemiah | 13 | 406 |
17 | Esther | The Book of Esther | 10 | 167 |
18 | Job | The Book of Job | 42 | 1070 |
19 | Psalms | The Book of Psalms | 150 | 2461 |
20 | Proverbs | The Proverbs | 31 | 915 |
21 | Ecclesiastes | Ecclesiastes, or, The Preacher | 12 | 222 |
22 | Song of Solomon | The Song of Solomon | 8 | 117 |
23 | Isaiah | The Book of the Prophet Isaiah | 66 | 1292 |
24 | Jeremiah | The Book of the Prophet Jeremiah | 52 | 1364 |
25 | Lamentations | The Lamentations of Jeremiah | 5 | 154 |
26 | Ezekiel | The Book of the Prophet Ezekiel | 48 | 1273 |
27 | Daniel | The Book of Daniel | 12 | 357 |
28 | Hosea | Hosea | 14 | 197 |
29 | Joel | Joel | 3 | 73 |
30 | Amos | Amos | 9 | 146 |
31 | Obadiah | Obadiah | 1 | 21 |
32 | Jonah | Jonah | 4 | 48 |
33 | Micah | Micah | 7 | 105 |
34 | Nahum | Nahum | 3 | 47 |
35 | Habakkuk | Habakkuk | 3 | 56 |
36 | Zephaniah | Zephaniah | 3 | 53 |
37 | Haggai | Haggai | 2 | 38 |
38 | Zechariah | Zechariah | 14 | 211 |
39 | Malachi | Malachi | 4 | 55 |
40 | Matthew | The Gospel According to Matthew | 28 | 1071 |
41 | Mark | The Gospel According to Mark | 16 | 678 |
42 | Luke | The Gospel According to Luke | 24 | 1151 |
43 | John | The Gospel According to John | 21 | 879 |
44 | The Acts | The Acts of the Apostles | 28 | 1007 |
45 | Romans | The Epistle of Paul the Apostle to the Romans | 16 | 433 |
46 | 1 Corinthians | The First Epistle of Paul the Apostle to the Corinthians | 16 | 437 |
47 | 2 Corinthians | The Second Epistle of Paul the Apostle to the Corinthians | 13 | 257 |
48 | Galatians | The Epistle of Paul to the Galatians | 6 | 149 |
49 | Ephesians | The Epistle of Paul the Apostle to the Ephesians | 6 | 155 |
50 | Philippians | The Epistle of Paul the Apostle to the Philippians | 4 | 104 |
51 | Colossians | The Epistle of Paul the Apostle to the Colossians | 4 | 95 |
52 | 1 Thessalonians | The First Epistle of Paul the Apostle to the Thessalonians | 5 | 89 |
53 | 2 Thessalonians | The Second Epistle of Paul the Apostle to the Thessalonians | 3 | 47 |
54 | 1 Timothy | The First Epistle of Paul the Apostle to Timothy | 6 | 113 |
55 | 2 Timothy | The Second Epistle of Paul the Apostle to Timothy | 4 | 83 |
56 | Titus | The Epistle of Paul to Titus | 3 | 46 |
57 | Philemon | The Epistle of Paul to Philemon | 1 | 25 |
58 | Hebrews | The Epistle of Paul the Apostle to the Hebrews | 13 | 303 |
59 | James | The General Epistle of James | 5 | 108 |
60 | 1 Peter | The First Epistle General of Peter | 5 | 105 |
61 | 2 Peter | The Second Epistle General of Peter | 3 | 61 |
62 | 1 John | The First Epistle General of John | 5 | 105 |
63 | 2 John | The Second Epistle of John | 1 | 13 |
64 | 3 John | The Third Epistle of John | 1 | 15 |
65 | Jude | The General Epistle of Jude | 1 | 25 |
66 | Revelation | The Revelation of St. John the Divine | 22 | 404 |