public List<MappingTool.Metadata> GetItems(SqlConnection connection, SqlTransaction transaction) { var output = new List<MappingTool.Metadata>(); var command = connection.CreateCommand(); command.Transaction = transaction; command.CommandText = Sql; command.Parameters.Add(new SqlParameter("@MetadataName", _metadataName)); using (var dr = command.ExecuteReader()) { while (dr.Read()) { var item = new MappingTool.Metadata(); item.MetadataId = new Guid(dr["MetadataId"].ToString()); item.MetadataTypeUid = new Guid(dr["MetadataTypeUid"].ToString()); if (dr["NodeUid"] != DBNull.Value) { item.NodeUid = new Guid(dr["NodeUid"].ToString()); } item.MetadataName = dr["MetadataName"].ToString(); item.MetadataValue = dr["MetadataValue"].ToString(); if (dr["RootMapUid"] != DBNull.Value) { item.RootMapUid = new Guid(dr["RootMapUid"].ToString()); } if (dr["DomainUid"] != DBNull.Value) { item.DomainUid = new Guid(dr["DomainUid"].ToString()); } item.Modified = dr["Modified"] == DBNull.Value ? null : (DateTime?)dr["Modified"]; item.ModifiedBy = dr["ModifiedBy"] == DBNull.Value? null : dr["ModifiedBy"].ToString(); item.Created = dr["Created"] == DBNull.Value ? null : (DateTime?)dr["Created"]; item.CreatedBy = dr["CreatedBy"] == DBNull.Value? item.ModifiedBy: dr["CreatedBy"].ToString(); output.Add(item); } } return output; }
private void detach_Metadatas(Metadata entity) { this.SendPropertyChanging(); entity.DescriptorType = null; }
partial void DeleteMetadata(Metadata instance);
partial void UpdateMetadata(Metadata instance);
partial void InsertMetadata(Metadata instance);
private void detach_Metadatas(Metadata entity) { this.SendPropertyChanging(); entity.Relationship = null; }
private void detach_Metadatas1(Metadata entity) { this.SendPropertyChanging(); entity.Node1 = null; }
private void attach_Metadatas(Metadata entity) { this.SendPropertyChanging(); entity.Node = this; }
private void detach_Metadatas(Metadata entity) { this.SendPropertyChanging(); entity.Domain = null; }