public static async Task <Models.ModelCatalog> FindOrCreateModelCatalogAsync
(
this CarContext carContext,
string makeName,
string modelName)
{
var query = @"EXECUTE [dbo].[FindOrCreateModelCatalog]
@MakeName
,@ModelName
,@Id OUTPUT";
var parMakeName = CarContextExtentions.CreateParNVarchar("@MakeName", makeName, 255);
var parModelName = CarContextExtentions.CreateParNVarchar("@ModelName", modelName, 255);
var parId = CarContextExtentions.ParIdOutput();
carContext.Database.ExecuteSqlRaw(
query,
parMakeName,
parModelName,
parId);
var model = new Models.ModelCatalog
{
Id = (Guid)parId.Value,
Name = modelName
};
return(model);
}
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);
}
