![\"json_server\"](\"https:\/\/cm-edgetun.pages.dev\/en-us\/research\/wp-content\/uploads\/2016\/11\/json_server.png\")
<\/p>\nJSON Server is a library that connects to a SQL database instance, stores JSON documents in tables and queries JSON documents through a JSON query language. It currently supports SQL Server\u00a0(version 2012 and onward)\u00a0and MariaDB (10.0 and onward)\u00a0as the underlying database, and three query languages: MongoDB query language, Azure DocumentDB query language and JSON Server’s own query language. JSON Server is not an independent database, but a middleware that accepts operations against JSON documents and translates them to SQL queries executed in the underlying system. As such, JSON Server provides a view of a JSON database, while completely operating on SQL Server or MariaDB.<\/p>\n
<\/p>\n
JSON Server\u00a0provides features a standard JSON database is expected to have. In addition, since JSON Server relies on SQL DBs, it inherits many features that are common in the relational world that are often missing\u00a0in native JSON databases.<\/p>\n
JSON Server needs the following libraries: (1) Json.NET (opens in new tab)<\/span><\/a>,\u00a0(2)\u00a0 ADO.NET driver for MySQL (opens in new tab)<\/span><\/a>, when you connect to\u00a0MariaDB.<\/p>\n JSON Server is a DLL library. You reference the library in your application and open a database\u00a0using\u00a0a SQL DB connection string.<\/p>\n \t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\n\t\n<\/div>\n \t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\n\t\n<\/div>\n \t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/section>\n\t\n\t\n Read the user manual<\/a> for the full language specification and programming API’s.<\/p>\n JSON Server is\u00a0currently available as a binary DLL here (opens in new tab)<\/span><\/a>.<\/p>\nGetting Started<\/h1>\n
\n\n\t\t\tsample code 1<\/h2>\n\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t<\/p>\nstring connectionString = @\"Data Source=(local);Initial Catalog=JsonTesting;Integrated Security=true;\";\r\nJsonServerConnection jdb = new JsonServerConnection(connectionString);\r\ntry {\r\n \/\/ Connect to a JSON database\r\n jdb.Open(true);\r\n\u00a0\u00a0jdb.Close();\r\n}\r\ncatch(DatabaseException e) {\r\n \/\/ Exception handling goes here\r\n}<\/pre>\nWhen the connection string points to a MariaDB instance, you open a JSON database in MariaDB:<\/div>\n\n\n\t\t\tsample code 2<\/h2>\n\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t<\/p>\nstring connectionString = @\"server=127.0.0.1;uid=root;pwd=xxx;database=jsontesting;\";\r\nJsonServerConnection jdb = new JsonServerConnection(connectionString, DatabaseType.Mariadb);\r\ntry {\r\n\u00a0 \/\/ Connect to a JSON database\r\n\u00a0 jdb.Open(true);\r\n\u00a0\u00a0jdb.Close();\r\n}\r\ncatch(DatabaseException e) {\r\n\u00a0 \/\/ Exception handling goes here\r\n}<\/pre>\nOnce you open a JSON database, you send queries through JsonServerConnection and retrieve results through IDataReader.<\/div>\n\n\n\t\t\tsample code 3<\/h2>\n\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t<\/p>\ntry {\r\n jdb.Open();\r\n if (!jdb.ContainsCollection(\"ExampleCollection\")) {\r\n jdb.CreateCollection(\"ExampleCollection\");\r\n }\r\n string doc1 = @\"{\"\"name\"\":\"\"sue\"\", \"\"age\"\":19, \"\"badges\"\":[\"\"blue\"\", \"\"black\"\"]}\";\r\n string doc2 = @\"{\"\"name\"\":\"\"bob\"\", \"\"age\"\":42, \"\"badges\"\":[\"green\"]}\";\r\n jdb.InsertJson(doc1, \"ExampleCollection\");\r\n jdb.InsertJson(doc2, \"ExampleCollection\");\r\n \r\n string queryString = @\"for d in ('ExampleCollection') WHERE d.age < 30 SELECT Doc(d)\";\r\n using(IDataReader reader = jdb.ExecuteReader(queryString)) {\r\n while (reader.Read()) {\r\n\u00a0\u00a0\u00a0 \/\/ Retrieve results through IDataReader\r\n\u00a0 }\r\n }\r\n jdb.Close();\r\n}\r\ncatch (Exception e) {\r\n \/\/ Exception handling goes here \r\n}<\/pre>\nDownload<\/h1>\n
Get Help<\/h1>\n