// public static SqlParameter CreateParameter(string parameterName, object value)
public static System.Data.SqlServerCe.SqlCeParameter CreateParameter(string parameterName, object value)
{
System.Data.SqlServerCe.SqlCeParameter newParam = new System.Data.SqlServerCe.SqlCeParameter();
// ret = new SqlParameter("Test", SqlDbType.DateTime);
newParam.ParameterName = parameterName;
if (value != null)
{
/*
* Gestisco le DateTime di C# per SQLServer
* In SQL non possono essere valorizzate come DateTime.MinDate quindi le considero un null
*
*/
if (value is DateTime)
{
// ret.SqlDbType = SqlDbType.DateTime;
DateTime valueDate = (DateTime)value;
if (valueDate == DateTime.MinValue)
{
newParam.Value = DBNull.Value;
}
else
{
newParam.Value = value;
}
}
else
{
newParam.Value = value;
}
}
else
{
newParam.Value = DBNull.Value;
}
return(newParam);
}
private void InitAdapter()
{
this._adapter = new System.Data.SqlServerCe.SqlCeDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "VoiceNote";
tableMapping.ColumnMappings.Add("Key", "Key");
tableMapping.ColumnMappings.Add("Data", "Data");
tableMapping.ColumnMappings.Add("Date", "Date");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [VoiceNote] WHERE (([Key] = @p1))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SqlServerCe.SqlCeParameter param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Guid;
param.IsNullable = true;
param.SourceColumn = "Key";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [VoiceNote] ([Key], [Data], [Date]) VALUES (@p1, @p2, @p3)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Guid;
param.IsNullable = true;
param.SourceColumn = "Key";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Binary;
param.IsNullable = true;
param.SourceColumn = "Data";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Date";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SqlServerCe.SqlCeCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [VoiceNote] SET [Key] = @p1, [Data] = @p2, [Date] = @p3 WHERE (([Key] = @p" +
"4))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p1";
param.DbType = System.Data.DbType.Guid;
param.IsNullable = true;
param.SourceColumn = "Key";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p2";
param.DbType = System.Data.DbType.Binary;
param.IsNullable = true;
param.SourceColumn = "Data";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p3";
param.DbType = System.Data.DbType.DateTime;
param.IsNullable = true;
param.SourceColumn = "Date";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SqlServerCe.SqlCeParameter();
param.ParameterName = "@p4";
param.DbType = System.Data.DbType.Guid;
param.IsNullable = true;
param.SourceColumn = "Key";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
