From a46c3bf452d287b50b2e7dd5a24f5995c9fd26f6 Mon Sep 17 00:00:00 2001 From: vnugent Date: Mon, 9 Jan 2023 15:09:13 -0500 Subject: Restructure --- .../src/SQL/SqlVariable.cs | 58 ++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 lib/VNLib.Plugins.Extensions.Data/src/SQL/SqlVariable.cs (limited to 'lib/VNLib.Plugins.Extensions.Data/src/SQL/SqlVariable.cs') diff --git a/lib/VNLib.Plugins.Extensions.Data/src/SQL/SqlVariable.cs b/lib/VNLib.Plugins.Extensions.Data/src/SQL/SqlVariable.cs new file mode 100644 index 0000000..b18d27b --- /dev/null +++ b/lib/VNLib.Plugins.Extensions.Data/src/SQL/SqlVariable.cs @@ -0,0 +1,58 @@ +/* +* Copyright (c) 2022 Vaughn Nugent +* +* Library: VNLib +* Package: VNLib.Plugins.Extensions.Data +* File: SqlVariable.cs +* +* SqlVariable.cs is part of VNLib.Plugins.Extensions.Data which is part of the larger +* VNLib collection of libraries and utilities. +* +* VNLib.Plugins.Extensions.Data is free software: you can redistribute it and/or modify +* it under the terms of the GNU General Public License as published +* by the Free Software Foundation, either version 2 of the License, +* or (at your option) any later version. +* +* VNLib.Plugins.Extensions.Data is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +* General Public License for more details. +* +* You should have received a copy of the GNU General Public License +* along with VNLib.Plugins.Extensions.Data. If not, see http://www.gnu.org/licenses/. +*/ + +using System; +using System.Data; + +namespace VNLib.Plugins.Extensions.Data.SQL +{ + /// + /// Property attribute that specifies the property is to be used for a given command variable + /// + [AttributeUsage(AttributeTargets.Property | AttributeTargets.Field)] + public sealed class SqlVariableAttribute : Attribute + { + public string VariableName { get; } + public DbType DataType { get; } + public ParameterDirection Direction { get; } + public int Size { get; } + public bool IsNullable { get; } + /// + /// Specifies the property to be used as an SQL variable + /// + /// Sql statement variable this property will substitute + /// The sql data the property will represent + /// Data direction during execution + /// Column size + /// Is this property allowed to be null + public SqlVariableAttribute(string variableName, DbType dataType, ParameterDirection direction, int size, bool isNullable) + { + this.VariableName = variableName; + this.DataType = dataType; + this.Direction = direction; + this.Size = size; + this.IsNullable = isNullable; + } + } +} -- cgit