=DateAdd("d", -1, Today())
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Friday, October 31, 2025
Wednesday, October 15, 2025
sql server - How to get detailed info about localdb
List of installed local DBs:
sqllocaldb iOutput:
MSSQLLocalDBMore details about selected:
sqllocaldb info MSSQLLocalDBOutput:
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\queryList of installed DBLocal versions:
sqllocaldb versionsOutput:
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;
}
}
Subscribe to:
Comments (Atom)