Oscar.EntityFrameworkCore.Sql
6.0.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Oscar.EntityFrameworkCore.Sql --version 6.0.0
NuGet\Install-Package Oscar.EntityFrameworkCore.Sql -Version 6.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Oscar.EntityFrameworkCore.Sql" Version="6.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Oscar.EntityFrameworkCore.Sql --version 6.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Oscar.EntityFrameworkCore.Sql, 6.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Oscar.EntityFrameworkCore.Sql as a Cake Addin #addin nuget:?package=Oscar.EntityFrameworkCore.Sql&version=6.0.0 // Install Oscar.EntityFrameworkCore.Sql as a Cake Tool #tool nuget:?package=Oscar.EntityFrameworkCore.Sql&version=6.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
快速开始
依赖包
<ItemGroup>
<PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="6.0.0" />
<PackageReference Include="Oscar.Data.SqlClient" Version="4.1.0" />
</ItemGroup>
示例
using Microsoft.EntityFrameworkCore;
using System;
namespace ConsoleApp12
{
internal class Program
{
static void Main(string[] args)
{
var connectStrings = "Server=10.1.1.66;Port=2003;User Id=SYSDBA;Password=szoscar55;Database=OSRDB;";
var optionsBuilder = new DbContextOptionsBuilder<UserDbContext>();
optionsBuilder.UseSql(connectStrings);
using (var context = new UserDbContext(optionsBuilder.Options))
{
var users = context.Users;
foreach (var user in users)
{
Console.WriteLine(user.Name);
}
}
Console.WriteLine("Hello, World!");
}
}
public class UserDbContext : DbContext
{
public UserDbContext(DbContextOptions<UserDbContext> options) : base(options)
{
}
public DbSet<User> Users { get; set; }
// create table users (id int primary key, name varchar(64), age int);
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity<User>(m =>
{
m.ToTable("USERS");
m.HasKey(m => m.Id);
m.Property(m => m.Name).HasMaxLength(64);
});
}
}
public class User
{
public int Id { get; set; }
public string Name { get; set; }
public int Age { get; set; }
}
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Microsoft.EntityFrameworkCore.Relational (>= 6.0.0)
- Oscar.Data.SqlClient (>= 4.1.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.