Error in EF Tutorial

[JN-LT]

Do I just ignore the "SQLite Error 14: 'unable to open database file'" error message, or was that not supposed to happen?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 488629d4-9bd2-42b5-4644-34e3f2baee59
• Version Independent ID: b38b9d14-6bad-12e0-8d2d-24b50bc4977e
• Content: Getting Started - EF Core
• Content Source: entity-framework/core/get-started/overview/first-app.md
• Product: entity-framework
• Technology: entity-framework-core
• GitHub Login: @Rick-Anderson
• Microsoft Alias: avickers

[JN-LT]

[Cameron-Gonzalez]

Did you ever figure this out? I was having the same issue.

[JN-LT]

Did you ever figure this out? I was having the same issue.

Nope. I'm looking for a better tutorial.

[Rick-Anderson]

Is that a valid path for your OS? That's a windows path.

change => options.UseSqlite(@"Data Source=C:\blogging.db"); to
=> options.UseSqlite(@"Data Source=blogging.db");

[JN-LT]

I am on Windows, so that should be a valid path. I am not an expert on Entity Framework, nor on GitHub. I was just trying to follow the tutorial on “https://docs.microsoft.com/en-us/ef/core/get-started/overview/first-app?tabs=visual-studio”, but it didn’t work. So I entered my feedback as requested at the bottom of that page. I didn’t see anything in the tutorial about any other changes I would need to make. Jeff Nygren Software Engineer II From: Rick Anderson ***@***.***> Sent: Monday, June 7, 2021 6:53 PM To: dotnet/EntityFramework.Docs ***@***.***> Cc: Jeff Nygren ***@***.***>; Author ***@***.***> Subject: Re: [dotnet/EntityFramework.Docs] Error in EF Tutorial (#3285) Is that a valid path for your OS? That's a windows path. change => options.UseSqlite(@"Data Source=C:\blogging.db"); to => options.UseSqlite(@"Data Source=blogging.db"); — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_dotnet_EntityFramework.Docs_issues_3285-23issuecomment-2D856334677&d=DwMCaQ&c=gF1t3YcGliJxvhK2Sl_RWGpK0dUxv3kAzNl4XNctI-U&r=hBBnp9kfi9sWQ9BA_gPiIRKJ_qEIjEProl5F5kGeA8o&m=CWPVND5BZLllNvg9LVQe3w4CxKbg0w05OJ0WzMOT2fY&s=3Odwdgph4vorS0WA6HOvxupCU7Eg3TQQHK_rwLlrj9w&e=>, or unsubscribe<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_ANFPIPURUBOOMDIIWFYRA73TRVLUJANCNFSM46H72ZEA&d=DwMCaQ&c=gF1t3YcGliJxvhK2Sl_RWGpK0dUxv3kAzNl4XNctI-U&r=hBBnp9kfi9sWQ9BA_gPiIRKJ_qEIjEProl5F5kGeA8o&m=CWPVND5BZLllNvg9LVQe3w4CxKbg0w05OJ0WzMOT2fY&s=wehbjrTCmgk_VX8bM0fkGdkF7bsaaeg_0XXJ8GVZ_Cg&e=>.

[ajcvickers]

@JN-LT Is it possible that you don't have permissions to create files in the root of C:?

[JN-LT]

I would guess that’s quite likely. Maybe the tutorial could be updated to suggest a better path for the db. Then noob users of the tutorial wouldn’t get stuck on this issue. Jeff Nygren Software Engineer II From: Arthur Vickers ***@***.***> Sent: Tuesday, June 8, 2021 11:24 AM To: dotnet/EntityFramework.Docs ***@***.***> Cc: Jeff Nygren ***@***.***>; Mention ***@***.***> Subject: Re: [dotnet/EntityFramework.Docs] Error in EF Tutorial (#3285) @JN-LT<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_JN-2DLT&d=DwMCaQ&c=gF1t3YcGliJxvhK2Sl_RWGpK0dUxv3kAzNl4XNctI-U&r=hBBnp9kfi9sWQ9BA_gPiIRKJ_qEIjEProl5F5kGeA8o&m=ZVzm5Lx8RLiHknNXqKvs34LVcE2wMS2aTGVPca5sf1M&s=wA9J0MjGmrMi10J7n2cItohB8ZeuMns7ZcK-fr74IS8&e=> Is it possible that you don't have permissions to create files in the root of C:? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_dotnet_EntityFramework.Docs_issues_3285-23issuecomment-2D856913328&d=DwMCaQ&c=gF1t3YcGliJxvhK2Sl_RWGpK0dUxv3kAzNl4XNctI-U&r=hBBnp9kfi9sWQ9BA_gPiIRKJ_qEIjEProl5F5kGeA8o&m=ZVzm5Lx8RLiHknNXqKvs34LVcE2wMS2aTGVPca5sf1M&s=7lLAa3SldtSpkPy-Wq4CaGhAt7jrVho0n4CC9sxitYY&e=>, or unsubscribe<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_ANFPIPX4U6UQRWPKOQB26QDTRY725ANCNFSM46H72ZEA&d=DwMCaQ&c=gF1t3YcGliJxvhK2Sl_RWGpK0dUxv3kAzNl4XNctI-U&r=hBBnp9kfi9sWQ9BA_gPiIRKJ_qEIjEProl5F5kGeA8o&m=ZVzm5Lx8RLiHknNXqKvs34LVcE2wMS2aTGVPca5sf1M&s=6oFJOLqQ_9Ljum111N9yKAm_-hog795zb4MfRbbD890&e=>.

[Rick-Anderson]

@ajcvickers I think we should use an OS independent and reliable path AND COMMENT ALTERNATIVES

[ErikEJ]

The issue is that there is no good general path, that cannot be misunderstood.

Like: C:\Users<YourName><FolderName>

Opens up for a universe of misunderstandings.

[ErikEJ]

Or add code that detects the platform and sets a suitable connection string? 😂

[smitpatel]

Or just put a dummy path which never works so user can put a path which they have access to in the OS they have.