Is there a way to read, what annotations are bound to a property ?
I have code like this.
    [PrimaryKey]
    [Identity]
    public int Id { get; set; }
    [ForeignKey]
    public int OwnerId { get; set; }
    [ForeignKey]
    public int RegionId { get; set; }
    public string Name { get; set; } = null!;
    public double Price { get; set; }
and I want to know if the property has Id has and Annotation, if yes what type. Also can a property have more than one annotation ?
My reading code looks like this, there is no annotation included
var type = typeof(TValue);
        var properties = type.GetProperties();
        var name = type.Name;
        string[] propertySQLstring = new string[properties.Length];
        string[] valueSQLstring = new string[properties.Length];
        for (int i = 0; i < properties.Length; i++)
        {
            if (i + 1 == properties.Length)
            {
                propertySQLstring[i] = properties[i].Name;
                valueSQLstring[i] = properties[i].GetValue(value)?.GetType() != typeof(string) ? properties[i].GetValue(value)?.ToString() : $"'{properties[i].GetValue(value)}'";
            }
            else
            {
                propertySQLstring[i] = properties[i].Name + ",";
                valueSQLstring[i] = properties[i].GetValue(value)?.GetType() != typeof(string) ? properties[i].GetValue(value)?.ToString() + ',' : $"'{properties[i].GetValue(value)}', ";
            }
        }
Thanks in advance.