private Entities.Data GetDataRecord(string key) { SqlCommand command = new SqlCommand("SELECT TOP 1 * FROM DbM_Data WHERE [Key] = @Key"); command.Parameters.Add( new SqlParameter("Key", key) { SqlDbType = System.Data.SqlDbType.VarChar, Size = 100 }); Entities.Data item = null; using (var connection = NewConnection()) { connection.Open(); command.Connection = connection; var reader = command.ExecuteReader(); while (reader.Read()) { item = ParseData(reader); } reader.Close(); connection.Close(); } return(item); }
private Entities.Data ParseData(SqlDataReader reader) { var item = new Entities.Data() { Id = (int)reader["Id"], Value = (string)reader["Value"], Key = (string)reader["Key"] }; return(item); }
private SqlCommand GetDataUpdateByKeyQueryCommand(Entities.Data data) { string query = @"UPDATE [dbo].[DbM_Data] SET [Value] = @Value WHERE [Key] = @Key; "; SqlCommand command = new SqlCommand(query); command.Parameters.Add(new SqlParameter("Key", data.Key) { SqlDbType = System.Data.SqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new SqlParameter("Value", data.Value) { SqlDbType = System.Data.SqlDbType.VarChar, Size = 255 }); return(command); }
private MySqlCommand GetDataUpdateByKeyQueryCommand(Entities.Data data) { string query = @"UPDATE DbM_Data SET `Value` = @Value WHERE `Key` = @Key; "; MySqlCommand command = new MySqlCommand(query); command.Parameters.Add(new MySqlParameter("Key", data.Key) { MySqlDbType = MySqlDbType.VarChar, Size = 50 }); command.Parameters.Add(new MySqlParameter("Value", data.Value) { MySqlDbType = MySqlDbType.VarChar, Size = 255 }); return(command); }
private SqlCommand GetDataInsertQueryCommand(Entities.Data data) { string query = @"INSERT INTO [dbo].[DbM_Data] ([Key] ,[Value]) VALUES (@Key ,@Value); "; SqlCommand command = new SqlCommand(query); command.Parameters.Add(new SqlParameter("Key", data.Key) { SqlDbType = System.Data.SqlDbType.VarChar, Size = 100 }); command.Parameters.Add(new SqlParameter("Value", data.Value) { SqlDbType = System.Data.SqlDbType.VarChar, Size = 255 }); return(command); }
private MySqlCommand GetDataInsertQueryCommand(Entities.Data data) { string query = @"INSERT INTO DbM_Data (`Key` ,`Value`) VALUES (@Key ,@Value); "; MySqlCommand command = new MySqlCommand(query); command.Parameters.Add(new MySqlParameter("Key", data.Key) { MySqlDbType = MySqlDbType.VarChar, Size = 100 }); command.Parameters.Add(new MySqlParameter("Value", data.Value) { MySqlDbType = MySqlDbType.VarChar, Size = 255 }); return(command); }