dart_mssql 0.0.3

MS-SQL Driver for Dart (32 & 64bits)

dart_mssql

Microsoft SQL Server Driver for Dart

Important

• Works only on Windows (32bits or 64bits)
• You have to install OLE DB Driver
• dart_mssql.dll in this repository is the 64 bits version. If you need the 32 bits version please compile the source and target as you need.

Example Usage

Demo code to perform Raw SQL queries

import 'package:dart_mssql/dart_mssql.dart';

MssqlConnection connection = MssqlConnection(host, databaseName, username, password);

int id = 1;
String cmd = "select * from mytable where id=$id"; // sorry! param binding not yet implemented!

SqlResult result = await connection.execute(cmd);

How To Compile the DLL with Microsoft Visual Studio 2017 Community Edition

• Before compile, you have to install Windows 10 SDK on your Microsoft Visual Studio 2017 Community Edition
• Open solution file dart_mssql\cpp\dart_mssql.sln with Microsoft Visual Studio 2017 Community Edition
• On "Solution Explorer" Panel right click on dart_mssql project and select "Rebuild"
• Put generated dart_mssql.dll into your project main folder (same folder of your pubspec.yaml file)