how to use asp.net core web api sqlite database in a host server

Question

Im using Visual Studio Mac. Im working on a asp.net core web api with sqlite database. it works fine in localhost. but doesn't work on host server. it gives 500 internal server error. I published it from a windows visual studio as ftp. I think my internal error is because of my sqlite configuration. its:

services.AddDbContext<ApplicationDbContext>(options => options.UseSqlite("Filename=./MyData.db"));

I think this configuration doesn't work in host and I have no idea about it. I just published it. please help me with it.

Check the exception that is thrown on the server. It should give you direction for the fix. — CodeFuller
– CodeFuller, Commented Mar 20, 2018 at 18:49
it gives me this error : SQLite Error 1: 'no such table: MyTable' — Sajjad Abedi
– Sajjad Abedi, Commented Mar 21, 2018 at 1:09

Alan Silva · Accepted Answer · 2018-03-21 01:43:51Z

1

I'd suggest you to:

Instead of using relative path on filename config, try using the absolute path.

Note: If it works, I'd recommend you to use

services.AddDbContext<ApplicationDbContext>(options => options.UseSqlite(String.Format("Filename={0}/MyData.db", AppDomain.CurrentDomain.BaseDirectory));

As you're using './MyData.db', I believe 'AppDomain.CurrentDomain.BaseDirectory' is going to be enough, other than that, you must use your correct file location.

[Solved]

Add this statement to the method you're calling.

try { //YOURCODE } catch (Exception e) { return StatusCode(500, $"An error has ocurred. Ex: e.InnerException.Message}"); }
Check the error message (no such table: MyTable)
Create the table.

Problem solved.

Best Regards

edited Mar 21, 2018 at 1:43

answered Mar 20, 2018 at 22:17

Alan Silva

1397 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Alan Silva Over a year ago

Your app generates any kind of log? Can you post here?

Sajjad Abedi Over a year ago

I published it on a host. And I test it with postman. It only gives me 500 internal server error. But other requests that dont related to the database work fine.

Alan Silva Over a year ago

I think you should output the error that is happening so we can have a better idea on what's going on.

Sajjad Abedi Over a year ago

Would you please tell me how to do that. I have no idea. Thanks.

Alan Silva Over a year ago

Add the following try catch on the method you're calling. try { //YOURCODE } catch (Exception e) { return StatusCode(500, $"An error has ocurred. Ex: {e.InnerException.Message}"); }

|

Collectives™ on Stack Overflow

how to use asp.net core web api sqlite database in a host server

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related