Wednesday, October 15, 2025

sql server - How to get detailed info about localdb

List of installed local DBs:
sqllocaldb i
Output:
MSSQLLocalDB
More details about selected:
sqllocaldb info MSSQLLocalDB
Output:
Name:               MSSQLLocalDB
Version:            15.0.4382.1
Shared name:
Owner:              domain\pirklj
Auto-create:        Yes
State:              Running
Last start time:    14.10.2025 14:36:27
Instance pipe name: np:\\.\pipe\LOCALDB#FF67DE7F\tsql\query
List of installed DBLocal versions:
sqllocaldb versions
Output:
Microsoft SQL Server 2016 (13.0.7037.1)
Microsoft SQL Server 2017 (14.0.3391.2)
Microsoft SQL Server 2019 (15.0.4382.1)
Microsoft SQL Server 2022 (16.0.1000.6)
Stopping and deleting of DBLocal instance, creating it with new higher version:
C:\Users\pirklj>sqllocaldb stop MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" stopped.

C:\Users\pirklj>sqllocaldb delete MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" deleted.

C:\Users\pirklj>sqllocaldb create MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" created with version 16.0.1000.6.

C:\Users\pirklj>sqllocaldb start MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" started.

Monday, October 13, 2025

c# - How to solve JSON deserialization problem

JSON deserialization returns this error:
Each parameter in the deserialization constructor on type 
'cieb_AXReportPrintDLG.ReportParamComboValues' must bind 
to an object property or field on deserialization. Each 
parameter name must match with a property or field on the 
object. Fields are only considered when 
'JsonSerializerOptions.IncludeFields' is enabled. 
The match can be case-insensitive.
All fields looks like OK. The problem is in the parameter names in the constructor. This version returns error:
public class ReportParamComboValues {

  /* description - for text */
  public string Description { get; set; }

  /* returned value for SSRS report param */
  public string Value { get; set; }

  public ReportParamComboValues( string _description, string _value ) {  
    this.Description = _description;
    this.Value = _value;
  }

}
This is working:
public class ReportParamComboValues {

  /* description - for text */
  public string Description { get; set; }

  /* returned value for SSRS report param */
  public string Value { get; set; }

  public ReportParamComboValues( string Description, string Value ) {  
    this.Description = Description;
    this.Value = Value;
  }

}