MS SQL Server

Microsoft SQL Server web site

Info

Class name: MsSqlStorage
Namespace: Chili.Opf3.Storages.MsSql
Current version: 3.0.15.1227.

How to use it

This short example demonstrates how to use the storage in your code.

C#  VB.NET  
// Create the instance of the MS SQL Server storage.
MsSqlStorage storage = new MsSqlStorage("user", "password", "host", "database");
// Set it as storage of the ObjectContext.
ObjectContext context = new ObjectContext(storage);

How to make the storage work with autoincrement values

Just specify the column that is autoincrement as Identitiy column of the database's table. That's it! The Opf3 storage class gets automatically the value for that column from the database and sets it in the persistent's property.

Download

This storage is part of the Opf3 Framework package (supported out of the box). Download the Opf3 Framework demo version to try it.

If you have any questions or need further assistance, please contact us.