Comments by Jordan Nash (Top 17 by date)

Yes I knew that. I forgot to delete that with _context.Jobs not doing anything. The reason why I put it in was I was studying the error https://docs.microsoft.com/en-us/dotnet/api/system.nullreferenceexception?view=net-5.0 and found out I wasn't instantiating Jobs. I'm not convinced instantiating it will help as the error only occurs with some records. If I delete var id=@model.ID in one place it will not change the output except it will report the error in the other table containing the variable. But if I delete the variable from both tables then it will stop the data appearing in the tables.

My problem is I can't attach the DB. None of the databases are appearing in my new connection profile which I assume means they are detached like you say. I will do this in VS Code.

So, if I run the first code snippet in the link you gave me.

use master
go
select db_name(database_id) as [Database Name],type_desc as [File Type], physical_name as [Database File Location] from sys.master_files
where database_id>=5 --exclude system databases

The localhost connection profile won't detect any database or log files with them in the desired directory path from where they were originally generated by EF Core.

This is the path. "C:\Users\Jordan". All the .mdf and .ldf files of different DBs are right there in my file explorer.

I tried to attach the file using this snippet from the link you provided to attach it.

USE [master]
GO
create database [Pitcher8] ON
(FileName='C:\Users\Jordan\Pitcher8.mdf'),
(FileName='C:\Users\Jordan\Pitcher8_log.ldf')
FOR ATTACH;

It results in this error.

Msg 5173, Level 16, State 2, Line 3
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.

Msg 1802, Level 16, State 7, Line 3
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

So I check error Msg 5173 and go here https://www.sqlserverlogexplorer.com/fix-sql-server-error-5173/

Then I do this.

CREATE DATABASE [Database] On PRIMARY
(NAME = N'Pitcher8',FILENAME = N'C:\Users\Jordan\Pitcher8.mdf')
LOG ON
(NAME = N'Pitcher8_log', FILENAME = N'C:\Users\Jordan\Pitcher8_log.ldf')
GO

Then I get this error.

Msg 5123, Level 16, State 10, Line 1
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Users\Jordan\Pitcher8.mdf'.

Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

File system permission errors? I don't know. Either way I went here.
https://www.sqlserverlogexplorer.com/fix-sql-server-error-5173/

Did this.

CREATE DATABASE [Database] On PRIMARY
(NAME = N'Pitcher8',FILENAME = N'C:\Users\Jordan\Pitcher8.mdf')
LOG ON
(NAME = N'Pitcher8_log', FILENAME = N'C:\Users\Jordan\Pitcher8_log.ldf')
GO

Which returned this error.

Msg 5123, Level 16, State 10, Line 1
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Users\Jordan\Pitcher8.mdf'.

Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

I try to attach it in SMS explorer. I can't even see any of the databases listed in C:\Users\Jordan of the Locate Database Files dialogue box. So I copy the files I want to C:\Data and open Pitcher8.mdf. Then I get this error.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Unable to open the physical file "C:\Data\Pitcher8.mdf.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5120)

What am I missing please?

My intention was to return the RegistrationID here which will be deleted though obviously that's not what I'm doing here because I don't know how to. Essentially the reason why you are confused is because I was confused.

I was trying to base my deletion method on the AssignUserRegistration method using the two parameters and do the reverse of that and also base it on the Delete actions generated by EF Core by default. Yes the null check is pointless and the compiler warned me. You could say I didn't know what to check for. At this point I am staring at the problem. I realize now I don't have to check for the UserID or JobId as EF Core will do a cascade delete so really I just have to work on the RegistrationID and workout how to delete it.

Shortened the question, by taking out irrelevant methods and class. I left the models as is as I am not sure they are irrelevant.

Thanks for your help Richard. While your answer solves the initial problem I listed in the title, it doesn't display a table list of unassigned users that don't contain matching ID of the newly created record. I'm wondering if you would know how to do that please? I'm stuck right now.

To elaborate, In the method JobsController.GetUnassignedUsersJobId(int? ID) I have ascertained that we are getting the last JobID but we are not comparing it to all the records in the userlist.

Thank you. Your code has actually solved my problem and all the listed problems appear now.

Because I want to map all the values in the "Data" column to rename a bunch of filenames in a drag drop box form. The values would would be written to all of the files. I wanted to have the user create csv files at the touch of a button and read their contents to the gridview and print it to the filename. The Description header is just a meta data column should they be creating several files and forget what all the data is for.

Is there something wrong with my approach there and if so how can I optimise it?

Hello,
Unfortunately I am having trouble compiling your code. Could you please show it in full with the loops and if statements if appropriate to this situation. Lastly, sorry but your use of the AddRange method doesn't appear to be working as it doesn't accept a string list.

I have already done this 3 days ago. No one responded. Perhaps I need to have more patience. I will put my previous comment from here to that question I already posted on that forum.

I changed the loadImageMetaData() method to this. The setTag() method was expecting a Bitmap of course so I instantiated one.

private void loadImageMetaData()
{
lstImageMetaData.Items.Clear();
Bitmap bmp = new Bitmap(_big_fileName);
EXIF.EXIFextractor er2 = new EXIF.EXIFextractor(ref bmp, "\n");
foreach (Pair s in er2)
{
lstImageMetaData.Items.Add(s.First + " : " + s.Second);
}
lstImageMetaData.SelectedIndex = lstImageMetaData.Items.Count - 1;
er2.setTag(0x5013,"Thumbnail Width");
}

So, I’m not getting the error anymore but it still won’t display the “Thumbnail Width” metadata. Do you know what I’m doing wrong, please?

Ah, yes I realize I had a method overload of the exact method where the error was. It's here in EXIFextractor.

public void setTag(int id, int len, short type, byte [] data)
{
PropertyItem p = CreatePropertyItem(type,id,len,data);
this.bmp.SetPropertyItem( p );//Error on this line.
buildDB(this.bmp.PropertyItems);
}