MS SQL Server support

Radzen apps can connect to Microsoft SQL Server databases. All you need to do is specify the connection string. Radzen will discover the schema and create an OData service which will expose the tables as OData entities.

  • Radzen supports only SQL Server authentication. Windows authentication is not supported.
  • The MS SQL server instance should be accessible via TCP. Named pipes or shared memory access is not supported.
  • The OData services that Radzen generates requires .NET Core. As a result Radzen will not create a MS SQL data source unless .NET Core is installed.
  • Full CRUD is supported except for tables that don’t have a primary key or have multiple primary keys.
  • Certain column types are not supported - hierarchyid, geography, sql_variant.

This tutorial will show you how to connect to a MS SQL Server database, read, add, update and delete data.

Prerequisites

Make sure you have installed .NET Core. Follow the installation instructions.

How to build the application

  • Step 1: Create and configure the application
  • Step 2: Add the MS SQL Server data source
  • Step 3: Automatically generate CRUD pages

Step 1: Create and configure the application

Create a new Radzen application by following the first step from the quickstart guide.

Step 2: Add the MS SQL Server data source

In this step we create a data source that connects to a MS SQL Server database.

  1. Open the application that you created in the previous step for editing.
  2. Click data to go to the My DataSources screen.
  3. Click new to add a new data source.
  4. Select MS SQL as data source type.
  5. Pick a Name for your data source.
  6. Enter the MS SQL Server connection info - server, port, database name, user and password.
  7. Click Next.
  8. Radzen will connect to the database and create entities for all tables.

Step 3: Automatically generate CRUD pages

  1. Check the Generate pages for CRUD operations check-box.
  2. Radzen will open Edit and Add pages by default in dialogs. Uncheck the check-box if you want to have navigation instead.
  3. Click Finish.

You can now run the application to verify that you have full CRUD support.

Optionally you can data-bind a data grid component manually

  1. Create a page property bound to the result of an invoke operation. Check the third step from the quickstart guide.
  2. Drag-and-drop a data grid component from the toolbox. Check the fourth step from the quickstart guide.
  3. Build and run the application.

Troubleshooting

If Radzen cannot connect to your SQL Server for some reason check the following troubleshooting instructions.

  1. Verify you have SQL Server authentication enabled. Radzen does not support Windows authentication at the moment.
  2. Check if TCP/IP access is enabled.
  3. If your MSSQL Server is running on a dynamic port the SQL Server Browser service should be enabled and running.
  4. If you are using a local SQL Express try specifying localhost\SQLEXPRESS as the server name.

If you hit a bug or want to get in touch please open an issue or send an email to info at radzen.com.

Make sure you are running the latest version: 1.6.0.