The process cannot access the file because it is being used by another process

Question

I tried to update me db schema in my code and after changing that if i run my application i ma getting the error as follows
The process cannot access the file because it is being used by another process

but my db is not opened anywhere so how to update the db schema

my code : i have changed my db schema from 107 to 108 in my code given below

can anyone help me to solve this ? thanks in advance

 static void CheckDbCompat()
        {
            EYE.Client.EyeApiAdapter api = new EYE.Client.EyeApiAdapter();
            string mainPath = Path.Combine(api.GetSqliteDataDir(), EYE.Model.DbCM.GetSqliteEyeMainFileName());

            if (File.Exists(mainPath))
            {
                string strSchemaVersion = DbCM.GetVar("dbSchemaVersion", "");
                if (!Int32.TryParse(strSchemaVersion, out int nSchemaVersion))
                {
                    nSchemaVersion = 106;
                }
                if (nSchemaVersion < 108)  //major change so Start Over
                {
                    BaseUtil.WriteToAppConfig("BootstrapState", "");
                }
            }
            
        }

Answer 1

None of the code you posted actually does anything other than check for a file to exist. This code doesn't open any files so it wouldn't trigger the error you're talking about. What you need to do is look at the file that is being locked (I assume mainPath) and ensure that any calls to open the file also close the file. That is what the using statement is for.

using (var stream = File.OpenWrite(mainPath))
{
};  //File is automatically closed when done, even on error

//File is never properly closed
var stream2 = File.OpenWrite(mainPath);
stream2.Close(); //Don't do this as it is not exception safe

//Will fail because file is already open, doesn't matter that it is the same process
var stream3 = File.OpenWrite(mainPath);

If you're using some data library or something that wraps all this then you need to ensure it is cleaning things up as well.

Answer 2

[I had stated that Mustafa Bamboat 's post was the answer for me: deleting the .vs file. But that only helps me to Rebuild once. Then when I run my solution halt the solution and Rebuild, the same error occurs. I wanted to Delete this "Answer" but learn.microsoft.com only lets you convert between an Answer and a Post -- there is no Delete option (why, Microsoft?)]