SQL connection instead of InMemory Repository

[sarawgimegha]

Hi,
I am trying to use this solution and trying to make the repository as SQL server instead of inMemory. When I edit the file for the InMemory Repository and make the connection to SQL server I always get error 500 for the GET request.

It says 'Object reference not set to an instance of an object".

Can anyone help me to resolve this issue.

Thanks,
Megha

[chihoyeung]

Hi,
If you show me your implementation, I can guide you thru it. But in short, you should create your own implementation of both IUserRepository and IGroupRepository and replace references to InMemoryRepository. See https://github.com/PowerDMS/Owin.Scim/wiki/03.-Customizing-Owin.Scim, specifically this part:

public void ConfigureContainer(IContainer container)
{
// Since the priority is lower than Owin.Scim's default int.MaxValue, this method will
// execute after all internal registrations occur.

// Replace any IUserRepository implementation and add our own.
container.Register<IUserRepository, MyDBUserRepository>(ifAlreadyRegistered: IfAlreadyRegistered.Replace);

// Replace any IGroupRepository implementation and add our own.
container.Register<IGroupRepository, MyDBGroupRepository>(ifAlreadyRegistered: IfAlreadyRegistered.Replace);
}

[sarawgimegha]

Thanks for your help. I am able to implement the sql server code. I had another query, as per my requirements my GET request will have the special character '\' in the URL. I would like to know will it work with the current implementation. I tried to test this using fiddler tool but that is unable to trigger the GET method. I would like to know is this the issue with fiddler or the HTTP GET does not allow to have any special character. Thanks, Megha

…

Sent from my iPhone

On 09-Jun-2017, at 6:26 PM, Chi Ho Yeung ***@***.***> wrote: Hi, If you show me your implementation, I can guide you thru it. But in short, you should create your own implementation of both IUserRepository and IGroupRepository and replace references to InMemoryRepository. See https://github.com/PowerDMS/Owin.Scim/wiki/03.-Customizing-Owin.Scim, specifically this part: public void ConfigureContainer(IContainer container) { // Since the priority is lower than Owin.Scim's default int.MaxValue, this method will // execute after all internal registrations occur. // Replace any IUserRepository implementation and add our own. container.Register<IUserRepository, MyDBUserRepository>(ifAlreadyRegistered: IfAlreadyRegistered.Replace); // Replace any IGroupRepository implementation and add our own. container.Register<IGroupRepository, MyDBGroupRepository>(ifAlreadyRegistered: IfAlreadyRegistered.Replace); } — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[chihoyeung]

a backslash is not valid for URLs, you might want to escape them:

https://stackoverflow.com/questions/1547899/which-characters-make-a-url-invalid
https://lists.w3.org/Archives/Public/www-validator/2011Feb/0024.html

Chi Ho

[sarawgimegha]

Hi, I am escaping them and writing it as %5C instead of \. Still it is not triggering the GET request in the SCIM solution. I tried it in fiddler tool, postman tool and google chrome. None of them detected this URL. What are the other solution to use \ in the URL. Also when I was using the scimqueryoptions it is not returning any data. It's always giving me empty result although I have data in my dataset. Can you also help me with this. Thanks, Megha

…

Sent from my iPhone

On 12-Jun-2017, at 7:22 PM, Chi Ho Yeung ***@***.***> wrote: a backslash is not valid for URLs, you might want to escape them: https://stackoverflow.com/questions/1547899/which-characters-make-a-url-invalid https://lists.w3.org/Archives/Public/www-validator/2011Feb/0024.html Chi Ho — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[dgioulakis]

@sarawgimegha What is the GET request you are attempting to make?