public int? Create(ConnectionString entity) { using (SqlCeConnection connection = new SqlCeConnection(ConnectionString)) { connection.Open(); SqlCeCommand command = new SqlCeCommand("INSERT INTO ConnectionStrings(Type, Name, Connection) VALUES (@Type, @Name, @Connection)", connection); command.Parameters.AddWithValue("@Type", (int)entity.Type); command.Parameters.AddWithValue("@Name", entity.Name); command.Parameters.AddWithValue("@Connection", entity.Connection); command.ExecuteNonQuery(); SqlCeCommand getId = new SqlCeCommand("SELECT @@IDENTITY AS Id", connection); object id = getId.ExecuteScalar(); return id == null ? (int?)null : Convert.ToInt32(getId.ExecuteScalar()); } }
public bool HasDuplicate(ConnectionString entity) { using (SqlCeConnection connection = new SqlCeConnection(ConnectionString)) { connection.Open(); SqlCeCommand command = new SqlCeCommand( @"SELECT CASE WHEN EXISTS ( SELECT 1 FROM ConnectionStrings WHERE Name = @Name AND ( @Id IS NULL OR ID <> @Id ) ) THEN 1 ELSE 0 END", connection); SqlCeParameter idParameter = new SqlCeParameter("@Id", System.Data.SqlDbType.Int); if (entity.ID.HasValue) idParameter.Value = entity.ID; else idParameter.Value = DBNull.Value; command.Parameters.Add(idParameter); command.Parameters.AddWithValue("@Name", entity.Name); return Convert.ToBoolean(command.ExecuteScalar()); } }
public XmlLoader(ConnectionString conString) { if (conString == null || string.IsNullOrWhiteSpace(conString.Connection)) throw new NullReferenceException("Путь к XML-файлу со снимком БД не указан!"); if (!File.Exists(conString.Connection)) throw new FileNotFoundException(string.Format("Файл [{0}] со снимком БД не найден!", conString.Connection)); _conString = conString; }
public void Update(ConnectionString entity) { using (SqlCeConnection connection = new SqlCeConnection(ConnectionString)) { connection.Open(); SqlCeCommand command = new SqlCeCommand("UPDATE ConnectionStrings SET Type = @Type , Name = @Name , Connection = @Connection WHERE ID = @Id", connection); command.Parameters.AddWithValue("@Id", entity.ID.Value); command.Parameters.AddWithValue("@Type", (int)entity.Type); command.Parameters.AddWithValue("@Name", entity.Name); command.Parameters.AddWithValue("@Connection", entity.Connection); command.ExecuteNonQuery(); } }
//public IDbLoader Loader { get; private set; } //public IDbSaver Saver { get; private set; } public DataBase(ConnectionString conString, IDbContext context) { ConString = conString; Context = context; //Context = Loader.Context; }
public void AddNewConnectionStringExecute(object o) { ConnectionString s = new ConnectionString() { Type = DataLayer.Enums.DataBaseType.SqlServer }; EditString(s); }
private void EditString(ConnectionString cString) { if (EditItem != null) { RefreshCollection(EditItem(this, new EditEventArgs() { editString = cString })); } }