@UniqueID error about dapper

[mgravell]

All the deep. There are some ways of configuring this, but honestly: in most cases it is more pragmatic just to:

new { obj.Foo, obj.Bar, obj.Blap }

to explicitly call out the things you want.

This is an interesting scenario, though. I wonder whether we could do something over in AOT-land to specify better restriction rules (in the AOT work, we have much better analysis tooling, and better ways of specifying configuration)

[mgravell]

I'm going to refer to the Apache license to answer that:

Unless required by applicable law or agreed to in writing, Licensor provides the Work (and each Contributor provides its Contributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for determining the appropriateness of using or redistributing the Work and assume any risks associated with Your exercise of permissions under this License.

If it works, great! I feel comfortable using it, as long as I have integration tests working.

[mgravell]

Can we see how you're invoking the SQL? Including (and in particular) the parameters? I can't do much without seeing the usage.

[mgravell]

I wonder, in particular, whether you somehow have a @uniqueId and @UniqueId (or similar), leading to this.

[mgravell]

In this example, Model is what defined the parameters. So: can we see the type that describes Model ? In particular, anything even remotely relating to unique id - regardless of kind (property, field, etc) or accessibility (public, private, etc)

[berets76]

Sorry I accidentally deleted previous comment.

Basically

using IDbConnection connection = new ConnectionFactory().CreateSQL();

if (connection != null)
{
    connection.Open();
    var result = connection.ExecuteScalar(UPDATE_QUERY, Model);

Model is the class with UniqueID field

Checking the Model class maybe I found the problem: my partial class has this signature
public partial class pro_ordine_composizione : GanttTask, INotifyPropertyChanged

in the Telerik.Windows.Controls.GanttView.GanttTask there is another uniqueid property.

So, I've my base class

public partial class pro_ordine_composizione 
{
	
	private string? _UniqueID;
	public string? UniqueID { get => _UniqueID; set { if (_UniqueID != value) { _UniqueID = value; OnPropertyChanged();} } }

my partial (with non relevant things)

public partial class pro_ordine_composizione : GanttTask, INotifyPropertyChanged

and finally the GanttTask

[Serializable]
public class GanttTask : PropertyChangedBase, IGanttTask, IDateRange, IResourceContainer, IHierarchical, IStateProvider, IMilestone, ISummary, IEditableHierarchical, IDependant
{
    private ObservableCollection<IResource> resources;

    private DateTime start;

    private DateTime end;

    private string title = string.Empty;

    private string description = string.Empty;

    private double progress;

    private DateTime? deadLine;

    private bool isExpired;

    private bool isExpiredUpdate = true;

    private bool isMilestone;

    private string uniqueId;

Maybe is this the problem ? But Dapper how deep goes to add parameters ?

[berets76]

I've already tested AOT with a part of our software (with good results), when do you think it might be "safe" to switch prod environment to AOT ?