mssql_connect 0.0.3

A Flutter plugin for Microsoft SQL Server (MSSQL) connectivity. Supports executing queries, managing connections, and SQL Server Change Tracking across multiple platforms.

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.