public FileEbook Add(FileEbook file) { var sqlQuery = "INSERT INTO FileDetails (FileName, FileContent) VALUES(@FileName, @FileContent); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var FileId = this._db.Query <int>(sqlQuery, file).Single(); file.Id = FileId; return(file); }
public FileEbook Update(FileEbook file) { var sqlQuery = "UPDATE FileDetails " + "SET FileName = @FileName, " + " FileContent = @FileContent " + "WHERE Id = @Id"; this._db.Execute(sqlQuery, file); return(file); }