How to access the same database file between two projects in a Visual Studio Solution? (2 Viewers)

[amorosik]

I've linked to a post that provides a solution
That link also contains an example (source code) of a program that uses the UcanAccess library
So if you write "..yet you refused to elaborate.." you should know you're writing something untrue
Why?

 

[Pat Hartman]

Sorry, I missed the link. "this" wasn't highlighted so it looked like there was no link.

 

[Pat Hartman]

OK. I looked at the link. How will the calling app locate the phone to make the connection assuming this is what @prabha_friend wants to do? Why anyone would store a live, shared BE on a phone is beyond me though. And because this tool does not support file sharing, what are other clients supposed to do while someone else has the BE opened exclusive?

 

[Edgar_]

I'd create a web API that both projects can access and be done with it.

If an .accdb file is what I must use, then I'd put the file in a Windows server. That way, if either of the projects sends an HTTP request, the server simply connects to the .accdb file, does its business and returns what you asked for.

If a sqlite database is to be used, same thing, but the server could be whatever, not necessarily Windows.

 

[amorosik]

... is beyond me though....

You're not the one who has to think about how the system should be set up
The colleague asked some questions; if you know the answer, you can help him
Otherwise, save the ink

 

[amorosik]

Sorry, I missed the link....

Yes, okay, you're excused

 

[prabha_friend]

Sorry Doc. Now only I searched about accdb and visual studio. We cannot migrate accdbs using Entity Framework Core. so now my question is: "How to use an sqlite3 database file between two projects inside a visual studio solution". Now it has become a complete "Other Software". Thanks Doc.

_dbContext.Database.EnsureCreated() does the Magic!