blocks|key|4627479|text|我认为问题在于，当使用SQLite提供程序时，EntityFramework核心不能自己创建文件夹。不知道使用其他基于文件的数据库提供程序时是否也会出现此问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4627480|我也有同样的问题：|4627481|我的数据源是这样的：optionsBuilder.UseSqlite(@"Data+Source=c:\foo_db\bar_db.db");|offset|length|style|BOLD|4627482|在c:\驱动器中创建了"foo_db"文件夹后，问题就解决了，EF+Core在该文件夹中创建了.db文件。|4627483|entityMap^0|0|0|A|1P|0|B|8|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@$F|T|G|U|H|I]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

i think the issue is that the EntityFramework Core can't create folders by itself while using SQLite provider. Don't know if the issue also appears when using other filebased database providers.

i had the same issue: 
my datasource was something like:
optionsBuilder.UseSqlite(@"Data Source=c:\foo_db\bar_db.db");

after i created the "foo_db" folder inside the c:\ drive, the problem was solved and EF Core created the .db file inside the folder.

blocks|key|2516038|text|解决了它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2516039|在我的实体类上，激活"break+on+all+exceptions“(在异常设置窗口中)会导致奇怪的”unable+to+open+database+file“exception.|2516040|Removing+|unordered-list-item|2516041|(”TableName“)属性导致在迁移类中出现一些奇怪的表创建行为。我认为只有在创建与类名不同的名称的表时才需要该属性。|ordered-list-item|2516042|2516043|2516044|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|P|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Solved it.

<ol>
<li>Activating "break on all exceptions" (in exceptions settings window) caused the weird 'unable to open database file' exception.</li>
<li>Removing the [Table("TableName")] attributes on my entity classes caused some strange table creation behavior in the migration class. I thought the attribute is only needed to create a table with another name than the class name.</li>
</ol>

blocks|key|2516099|text|我还解决了这个问题，用"OutOfProcess".替换了项目文件(*.csproj)中的"InProcess“我希望这对你也有帮助。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2516100|entityMap^0|C|C|1A|9|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

I also solved the problem by replacing "InProcess" in the project file (*.csproj) with "OutOfProcess". I hope it helps you too.

blocks|key|6044155|text|实际问题是在迁移和数据库更新后，*.db文件不会自动转到bin文件夹。您只需选择*.db并更改属性"Copy+to+Output+Directory“=+"Copy+if+newer”。这将解决问题..请试着让我们知道。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6044156|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The Actual issue is after migration and database update *.db file doesn't go to bin folder automatically.
You Just need to select the *.db and change properties "Copy to Output Directory" = "Copy if newer".
This will resolve the issue.. please try and let us know.

blocks|key|6044067|text|截至2019年8月仍在发生。我尝试了上面的所有方法，但在两个小时后，我的解决方案是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6044068|将此类添加到应用程序中的任何位置：|6044069|internal+class+CurrentDirectoryHelpers
{
++++internal+const+string+AspNetCoreModuleDll+=+"aspnetcorev2_inprocess.dll";
++++[System.Runtime.InteropServices.DllImport("kernel32.dll")]
++++private+static+extern+IntPtr+GetModuleHandle(string+lpModuleName);
++++[System.Runtime.InteropServices.DllImport(AspNetCoreModuleDll)]
++++private+static+extern+int+http_get_application_properties(ref+IISConfigurationData+iiConfigData);
++++[System.Runtime.InteropServices.StructLayout(System.Runtime.InteropServices.LayoutKind.Sequential)]
++++private+struct+IISConfigurationData
++++{
++++++++public+IntPtr+pNativeApplication;
++++++++[System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.BStr)]
++++++++public+string+pwzFullApplicationPath;
++++++++[System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.BStr)]
++++++++public+string+pwzVirtualApplicationPath;
++++++++public+bool+fWindowsAuthEnabled;
++++++++public+bool+fBasicAuthEnabled;
++++++++public+bool+fAnonymousAuthEnable;
++++}
++++public+static+void+SetCurrentDirectory()
++++{
++++++++try
++++++++{
++++++++++++//+Check+if+physical+path+was+provided+by+ANCM
++++++++++++var+sitePhysicalPath+=+Environment.GetEnvironmentVariable("ASPNETCORE_IIS_PHYSICAL_PATH");
++++++++++++if+(string.IsNullOrEmpty(sitePhysicalPath))
++++++++++++{
++++++++++++++++//+Skip+if+not+running+ANCM+InProcess
++++++++++++++++if+(GetModuleHandle(AspNetCoreModuleDll)+==+IntPtr.Zero)
++++++++++++++++{
++++++++++++++++++++return;
++++++++++++++++}
++++++++++++++++IISConfigurationData+configurationData+=+default(IISConfigurationData);
++++++++++++++++if+(http_get_application_properties(ref+configurationData)+!=+0)
++++++++++++++++{
++++++++++++++++++++return;
++++++++++++++++}
++++++++++++++++sitePhysicalPath+=+configurationData.pwzFullApplicationPath;
++++++++++++}
++++++++++++Environment.CurrentDirectory+=+sitePhysicalPath;
++++++++}
++++++++catch
++++++++{
++++++++++++//+ignore
++++++++}
++++}
}|code-block|syntax|javascript|6044070|然后，在Program.cs中将其称为第一件事，如下所示：|6044071|public+static+void+Main(string[]+args)
{
++++CurrentDirectoryHelpers.SetCurrentDirectory();
++++CreateWebHostBuilder(args).Build().Run();
}|6044072|My+Setup|offset|length|style|BOLD|6044073|将2.2.6|6044074|Connection字符串设置为"Filename=./mydatabase.db"|unordered-list-item|CODE|6044075|
的|6044076|AspNet核心2.2+Web+|6044077|EF核心SQLite|6044078|6044079|Credits|6044080|我是从这篇文章中摘录的：https://elanderson.net/2019/02/asp-net-core-configuration-issue-with-in-process-hosting/|6044081|entityMap|0|LINK|mutability|MUTABLE|url|https://elanderson.net/2019/02/asp-net-core-configuration-issue-with-in-process-hosting/^0|0|0|0|0|0|0|8|0|0|G|Q|0|0|0|0|0|0|7|0|C|2G|0|0^^$0|@$1|2|3|4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1I|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1J|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1K|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1L|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1M|8|@$O|1N|P|1O|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1P|8|@]|9|@]|A|$]]|$1|U|3|V|5|W|7|1Q|8|@$O|1R|P|1S|Q|X]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1T|8|@]|9|@]|A|$]]|$1|10|3|11|5|W|7|1U|8|@]|9|@]|A|$]]|$1|12|3|13|5|W|7|1V|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|1X|8|@$O|1Y|P|1Z|Q|R]]|9|@]|A|$]]|$1|17|3|18|5|6|7|20|8|@]|9|@$O|21|P|22|1|23]]|A|$]]|$1|19|3|-4|5|6|7|24|8|@]|9|@]|A|$]]]|1A|$1B|$5|1C|1D|1E|A|$1F|1G]]]]

Still happening as of August 2019. Tried all of the above, but the fix for me after 2 good hours was this:

Add this class anywhere in the application:

<pre class="lang-cs prettyprint-override"><code>internal class CurrentDirectoryHelpers
{
 internal const string AspNetCoreModuleDll = "aspnetcorev2_inprocess.dll";
 [System.Runtime.InteropServices.DllImport("kernel32.dll")]
 private static extern IntPtr GetModuleHandle(string lpModuleName);
 [System.Runtime.InteropServices.DllImport(AspNetCoreModuleDll)]
 private static extern int http_get_application_properties(ref IISConfigurationData iiConfigData);
 [System.Runtime.InteropServices.StructLayout(System.Runtime.InteropServices.LayoutKind.Sequential)]
 private struct IISConfigurationData
 {
 public IntPtr pNativeApplication;
 [System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.BStr)]
 public string pwzFullApplicationPath;
 [System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.BStr)]
 public string pwzVirtualApplicationPath;
 public bool fWindowsAuthEnabled;
 public bool fBasicAuthEnabled;
 public bool fAnonymousAuthEnable;
 }
 public static void SetCurrentDirectory()
 {
 try
 {
 // Check if physical path was provided by ANCM
 var sitePhysicalPath = Environment.GetEnvironmentVariable("ASPNETCORE_IIS_PHYSICAL_PATH");
 if (string.IsNullOrEmpty(sitePhysicalPath))
 {
 // Skip if not running ANCM InProcess
 if (GetModuleHandle(AspNetCoreModuleDll) == IntPtr.Zero)
 {
 return;
 }
 IISConfigurationData configurationData = default(IISConfigurationData);
 if (http_get_application_properties(ref configurationData) != 0)
 {
 return;
 }
 sitePhysicalPath = configurationData.pwzFullApplicationPath;
 }
 Environment.CurrentDirectory = sitePhysicalPath;
 }
 catch
 {
 // ignore
 }
 }
}
</code></pre>

Then, call it first thing in Program.cs, like this:

<pre class="lang-cs prettyprint-override"><code>public static void Main(string[] args)
{
 CurrentDirectoryHelpers.SetCurrentDirectory();
 CreateWebHostBuilder(args).Build().Run();
}
</code></pre>

My Setup

<ul>
<li>AspNet Core 2.2 Web API</li>
<li>EF Core SQLite 2.2.6</li>
<li>Connection String set to <code>"Filename=./mydatabase.db"</code></li>
</ul>

Credits

I took it from this post:
<a href="https://elanderson.net/2019/02/asp-net-core-configuration-issue-with-in-process-hosting/" rel="nofollow noreferrer">https://elanderson.net/2019/02/asp-net-core-configuration-issue-with-in-process-hosting/</a>

blocks|key|1880187|text|我在同样的情况下，我的问题被解决了，向下移动像图片：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1880188|​|1880189|📷|atomic|offset|length|1880190|firts+"AllowedHosts":+"*",和他们|style|CODE|1880191|"ConnectionStrings":+{
++++"DefaultConnection":+"DbExample"
++}|code-block|syntax|javascript|1880192|这就是我在NetCore+2.1版本中遇到的问题，我希望这能帮助你:)|1880193|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1ef7a271b891990d65663c934d136f73.png|imageAlt^0|0|0|0|1|0|0|6|K|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@$G|15|H|16|1|17]]|A|$]]|$1|I|3|J|5|6|7|18|8|@$G|19|H|1A|K|L]]|9|@]|A|$]]|$1|M|3|N|5|O|7|1B|8|@]|9|@]|A|$P|Q]]|$1|R|3|S|5|6|7|1C|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10|11|-4]]]]

i Was in the Same Situation my problem was fix by Moving down Down like the pic :

<a href="https://i.stack.imgur.com/tacrz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tacrz.png" alt="enter image description here"></a>
 firts <code>"AllowedHosts": "*",</code> and them 

<pre><code>"ConnectionStrings": {
 "DefaultConnection": "DbExample"
 }
</code></pre>

thats happend to me with the Version NetCore 2.1 i hope this can help you out :)

blocks|key|1875061|text|您可以在您的DbContext类中尝试以下代码:|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1875062|++protected+override+void+OnConfiguring(+DbContextOptionsBuilder+optionsBuilder)
++++{
++++++++var+dbPath+=+Path.Combine(ApplicationData.Current.LocalFolder.Path,+"YourDbName.db");
++++++++optionsBuilder.UseSqlite("Filename+=+"%2BdbPath);
++++++++base.OnConfiguring(optionsBuilder);
++++}|code-block|syntax|javascript|1875063|entityMap^0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

You can try this code inside your DbContext class :

<pre><code> protected override void OnConfiguring( DbContextOptionsBuilder optionsBuilder)
 {
 var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, "YourDbName.db");
 optionsBuilder.UseSqlite("Filename = "+dbPath);
 base.OnConfiguring(optionsBuilder);
 }
</code></pre>

blocks|key|2516386|text|在我的案例中，windows10勒索软件保护阻止LINQPad.DriverProxy.LINQPad.Drivers.EFCore.exe访问该文件。允许它在勒索软件保护下进行->阻止历史记录可防止引发此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2516387|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case windows 10 Ransomware Protection was preventing LINQPad.DriverProxy.LINQPad.Drivers.EFCore.exe from accessing the file. Allowing it under ransomware protection -> block history prevented this error from being raised.

blocks|key|1875073|text|这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1875074|++++static+SqliteConnection+CreateConnection()
++++{
++++++++string+dbPath+=+Environment.CurrentDirectory+%2B+@"\Database.sqlite";
++++++++SqliteConnection+conn+=+new+SqliteConnection(@"Data+Source+=+"+%2B+dbPath);
++++++++try
++++++++{
++++++++++++conn.Open();
++++++++}
++++++++catch+{+}
++++++++return+conn;
++++}|code-block|syntax|javascript|1875075|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will work for me:

<pre><code> static SqliteConnection CreateConnection()
 {
 string dbPath = Environment.CurrentDirectory + @"\Database.sqlite";
 SqliteConnection conn = new SqliteConnection(@"Data Source = " + dbPath);
 try
 {
 conn.Open();
 }
 catch { }
 return conn;
 }
</code></pre>

blocks|key|1880305|text|当使用像IIS这样的web服务器时，确保允许用于运行应用程序的用户(例如，对于IIS可以是application+pool+identity)对SQLite数据库文件和包含该文件的目录进行写访问(请参阅此question)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1880306|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/aspnet/core/host-and-deploy/iis/advanced?view=aspnetcore-5.0#application-pool-identity|1|https://serverfault.com/questions/57596/why-do-i-get-sqlite-error-unable-to-open-database-file^0|19|P|0|2U|8|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

When using a web server like IIS, ensure that write access to both the SQLite database file and the directory containing that file is allowed (see this <a href="https://serverfault.com/questions/57596/why-do-i-get-sqlite-error-unable-to-open-database-file">question</a>) to the user used for running the app (which e.g. for IIS could be the <a href="https://docs.microsoft.com/en-us/aspnet/core/host-and-deploy/iis/advanced?view=aspnetcore-5.0#application-pool-identity" rel="nofollow noreferrer">application pool identity</a>).

I am getting an

SQLite Error 14: 'unable to open database file'

with EF Core code first, no idea why. I worked fine the first time, the database file got created in c:\users\username\AppData\Local\Packages\PackageId\LocalState.

Then I deleted the database file and the code first migration and ModelSnapshot classes and created a new migration (I am calling DbContext.Database.Migrate() on app start to automatically execute them). Now the database cannot be created again.

SQLite Error 14: 'unable to open database file' with EF Core code first

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我得到了一个SQLite错误14：‘无法打开数据库文件’首先使用EF核心代码，不知道为什么。我第一次工作得很好，数据库文件是用c:\users\username\AppData\Local\Packages\PackageId\LocalState.创建的然后，我删除了数据库文件和代码，首先是迁移和ModelSnapshot类，然后创建了一个新的迁移(我在app start上调用DbContext

问SQLite错误14：'unable to open database file‘with EF Core code first
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQLite错误14：'unable to open database file‘with EF Core code firstEN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQLite错误14：'unable to open database file‘with EF Core code first
EN