Accessing a database


For security reasons, accessing a database is always done on the server-side, not the client-side. In fact, the "Connection String", which includes the URL and password of the database, should not be visible to the end-user.

The client-side (ie. the CSHTML5-based front-end) communicates with the server (for example an ASP.NET / WCF Service application) via one of the following:



You can download a sample client/server application from the following URL:

The sample demonstrates how to pass entities between the client and the server. IMPORTANT: the sample requires version 1.0 Beta 12.4 or newer. You can download the very latest build from the Pre-Releases section of the forums.

Although there is no database in the sample (instead, there is static dictionary on the server-side), database access can be easily added by modifying the file "Service1.svc.cs" located in the "WcfService1" project.

Let's assume that you have an SqlServer database which contains a table named "ToDoItemsTable" that has the following columns:

  • Description (type: varchar(max))
  • ID (type: uniqueidentifier)
  • CreationDate (type: date)

To retrieve the list of ToDo items from the database instead of the static dictionary, open the file "Service1.svc.cs" and replace the following code:

private static Dictionary<Guid, ToDoItem> _todos = new Dictionary<Guid, ToDoItem>();

public List<ToDoItem> GetToDos()
    return _todos.Values.ToList();

with this one:

public List<ToDoItem> GetToDos()
    List<ToDoItem> result = new List<ToDoItem>();


    // In a using statement, acquire the SqlConnection as a resource.
    using (SqlConnection connection = new SqlConnection(connectionString))
        // Open the SqlConnection.

        // The following code uses an SqlCommand based on the SqlConnection.
        using (SqlCommand command = new SqlCommand("SELECT Description, ID, CreationDate FROM ToDoItemsTable", connection))
        using (SqlDataReader reader = command.ExecuteReader())
            // Traverse each row of the table:
            while (reader.Read())
                // Read the values of the "Description", "ID", and "CreationDate" columns:
                string todoDescription = reader.GetString(0);
                Guid todoId = reader.GetGuid(1);
                DateTime todoCreationDate = reader.GetDateTime(2);

                // Create a ToDo item instance that will be sent to the CSHTML5 client-side application:
                var todo = new ServiceReference2.ToDoItem()
                    Description = todoDescription,
                    Id = todoId,
                    CreationDate = todoCreationDate

    return result;


Contact Us

Please click here for contact information.