mssql_connect

A Flutter plugin for Microsoft SQL Server (MSSQL) connectivity. This plugin allows you to connect to MS SQL Server and execute queries directly from your Flutter application.

Features

Connect to Microsoft SQL Server.
Execute SQL queries (SELECT, INSERT, UPDATE, DELETE).
Support for multiple platforms (Android, Windows).
Easy to use API.

Installation

Add mssql_connect to your pubspec.yaml file:

dependencies:
  mssql_connect: ^0.0.1

Then run:

flutter pub get

Usage

Direct Connection

import 'package:mssql_connect/mssql_connect.dart';

void main() async {
  final connection = MssqlConnect();
  
  bool connected = await connection.connect(
    ip: '192.168.1.100',
    port: '1433',
    database: 'your_db',
    username: 'sa',
    password: 'your_password',
  );

  if (connected) {
    var results = await connection.executeQuery("SELECT * FROM Users");
    print(results);
  }
}

Change Tracking (MSSQL)

Efficiently track data changes using SQL Server's Change Tracking feature.

// 1. Get current version
final currentVersion = await connection.getChangeTrackingVersion();

// 2. Check for changes in a specific table
final hasChanges = await connection.hasTableChanges(
  tableName: 'Products',
  lastVersion: lastSyncVersion,
);

if (hasChanges) {
  // 3. Get detailed changes (Operation type and Primary Key)
  final changes = await connection.getTableChanges(
    tableName: 'Products',
    lastVersion: lastSyncVersion,
    primaryKeyColumn: 'ProductId',
  );

  for (var change in changes) {
    print('Type: ${change['operation']}'); // I, U, or D
    print('ID: ${change['primaryKey']}');
  }
}

Platform Support

Android	Windows
✅	✅

License

This project is licensed under the MIT License - see the LICENSE file for details.