public static async Task <FeatureCatalog> FindOrCreateFeatureCatalogAsync( this CarContext carContext, Guid descriptionCatalogId, string name, bool?standart, string value) { var query = @"EXECUTE [dbo].[FindOrCreateFeatureCatalog] @DescriptionCatalogId, @Name, @Standart, @Value"; var parDescId = CarContextExtentions.CreateParGuid("@DescriptionCatalogId", descriptionCatalogId); var parName = CarContextExtentions.ParNameInput(name); var parStandart = CarContextExtentions.CreateParBit("@Standart", standart); var parValue = CarContextExtentions.CreateParNVarchar("@Value", value, 250); return(carContext.FeatureCatalog.FromSqlRaw( query, parDescId, parName, parStandart, parValue ).AsEnumerable().First()); }
public static async Task <DescriptionCatalog> FindOrCreateDescriptionCatalogAsync(this CarContext carContext, string name) { var query = @"EXECUTE [dbo].[FindOrCreateDescriptionCatalog] @Name"; var parName = CarContextExtentions.ParNameInput(name); return(carContext.DescriptionCatalog.FromSqlRaw(query, parName).AsEnumerable().First()); }
public static Models.MakeCatalog FindOrCreateMakeCatalogAsync(this CarContext carContext, string name) { var query = @"EXECUTE [dbo].[FindOrCreateMakeCatalog] @Name ,@Id OUTPUT"; var parName = CarContextExtentions.ParNameInput(name); var parId = CarContextExtentions.ParIdOutput(); carContext.Database.ExecuteSqlRaw( query, parName, parId); var mark = new Models.MakeCatalog { Id = (Guid)parId.Value, Name = name }; return(mark); }