EF6+.NET Framework+ Postgre issue

candrd · 2024-01-24T18:38:11.508Z

Maybe the title is confusing but i need help, i want a really basic code first app. I researched 3 days but i can't find any solution to this problem. When i try to enable-migrations PMC gives me this error. I can share my codes if you want. My connectionString is true.So don't ask me this please. ```An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure.```

A

Angius•1/24/24, 6:40 PM

Seeing the code would be nice, yes

A

Angius•1/24/24, 6:41 PM

Also, ensure Postgres is actually running

C

candrdOP•1/24/24, 6:41 PM

Postgres is running, my java db is working rn

C

candrdOP•1/24/24, 6:43 PM

Kisiler.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class Kisiler
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; }
        public string Surname { get; set; } 
        public int Number { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class Kisiler
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; }
        public string Surname { get; set; } 
        public int Number { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class Kisiler
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; }
        public string Surname { get; set; } 
        public int Number { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class Kisiler
    {
        [Key]
        public int Id { get; set; }
        public string Name { get; set; }
        public string Surname { get; set; } 
        public int Number { get; set; }
    }
}

J

Jimmacle•1/24/24, 6:43 PM

your dbcontext registration/instantiation is the important part here

C

candrdOP•1/24/24, 6:44 PM

AppContext.cs

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class AppContext : DbContext
    {
        AppContext(): base("Name=AppContext") { }
        DbSet<Kisiler> Kisilers { get; set; } 
    }
}

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class AppContext : DbContext
    {
        AppContext(): base("Name=AppContext") { }
        DbSet<Kisiler> Kisilers { get; set; } 
    }
}

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class AppContext : DbContext
    {
        AppContext(): base("Name=AppContext") { }
        DbSet<Kisiler> Kisilers { get; set; } 
    }
}

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace RehberAppNew
{
    public class AppContext : DbContext
    {
        AppContext(): base("Name=AppContext") { }
        DbSet<Kisiler> Kisilers { get; set; } 
    }
}

J

Jimmacle•1/24/24, 6:44 PM

so where is the dbcontext getting the connection string from?

J

Jimmacle•1/24/24, 6:45 PM

or is old EF weird and magic about how it works

C

candrdOP•1/24/24, 6:45 PM

App.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8.1" />
  </startup>
  <entityFramework>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" />
    </providers>
    <defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, EntityFramework6.Npgsql" />
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <add name="Npgsql Provider" invariant="Npgsql" description=".NET Framework Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </DbProviderFactories>
  </system.data>
  <connectionStrings>
    <add name="AppContext" providerName="Npgsql" connectionString="Server=localhost;Database=directory;User Id= postgres;Password=pst.grs" />
  </connectionStrings>
</configuration>

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8.1" />
  </startup>
  <entityFramework>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" />
    </providers>
    <defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, EntityFramework6.Npgsql" />
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <add name="Npgsql Provider" invariant="Npgsql" description=".NET Framework Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </DbProviderFactories>
  </system.data>
  <connectionStrings>
    <add name="AppContext" providerName="Npgsql" connectionString="Server=localhost;Database=directory;User Id= postgres;Password=pst.grs" />
  </connectionStrings>
</configuration>

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8.1" />
  </startup>
  <entityFramework>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" />
    </providers>
    <defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, EntityFramework6.Npgsql" />
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <add name="Npgsql Provider" invariant="Npgsql" description=".NET Framework Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </DbProviderFactories>
  </system.data>
  <connectionStrings>
    <add name="AppContext" providerName="Npgsql" connectionString="Server=localhost;Database=directory;User Id= postgres;Password=pst.grs" />
  </connectionStrings>
</configuration>

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8.1" />
  </startup>
  <entityFramework>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" />
    </providers>
    <defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, EntityFramework6.Npgsql" />
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <add name="Npgsql Provider" invariant="Npgsql" description=".NET Framework Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </DbProviderFactories>
  </system.data>
  <connectionStrings>
    <add name="AppContext" providerName="Npgsql" connectionString="Server=localhost;Database=directory;User Id= postgres;Password=pst.grs" />
  </connectionStrings>
</configuration>

J

Jimmacle•1/24/24, 6:45 PM

i have to ask, is there a reason you're using such an outdated version of .NET?

JJimmacle so where is the dbcontext getting the connection string from?

C

candrdOP•1/24/24, 6:45 PM

app.config

A

Angius•1/24/24, 6:46 PM

Ah, it's 4.8

A

Angius•1/24/24, 6:46 PM

I know nothing about it, so you'll have to rely on our resident archaeologists for help lol

JJimmacle i have to ask, is there a reason you're using such an outdated version of .NET?

C

candrdOP•1/24/24, 6:46 PM

how can i use in winform application otherwise?

J

Jimmacle•1/24/24, 6:46 PM

you can use winforms in .NET 8

C

candrdOP•1/24/24, 6:46 PM

wait a second

C

candrdOP•1/24/24, 6:46 PM

how?

A

Angius•1/24/24, 6:47 PM

Unless you mean webforms

J

Jimmacle•1/24/24, 6:47 PM

i personally wouldn't, but there's nothing stopping you

A

Angius•1/24/24, 6:47 PM

dotnet new winforms

dotnet new winforms

dotnet new winforms

dotnet new winforms

J

Jimmacle•1/24/24, 6:47 PM

<UseWindowsForms>true</UseWindowsForms> in your csproj

J

Jimmacle•1/24/24, 6:47 PM

or that

A

Angius•1/24/24, 6:47 PM

Or $newproject

AAngius Or $newproject

M

MODiX•1/24/24, 6:47 PM

When creating a new project, prefer using .NET over .NET Framework, unless you have a very specific reason to be using .NET Framework.
.NET Framework is now legacy code and only get security fix updates, it no longer gets new features and is not recommended.
https://cdn.discordapp.com/attachments/569261465463160900/899381236617855016/unknown.png