MmKZJB5P

1//instalirati code generator ako prethodno nije instaliran na sistemu
2dotnet tool install -g dotnet-aspnet-codegenerator
3
4
5//prekopira se u terminal da doda u projekat pakete koji su potrebni za konekciju na bazu
6
7dotnet add package Microsoft.EntityFrameworkCore.Design
8dotnet add package Microsoft.EntityFrameworkCore.SqlServer.Design
9dotnet add package Microsoft.VisualStudio.Web.CodeGeneration.Design
10dotnet add package Microsoft.EntityFrameworkCore.SqlServer
11dotnet add package Microsoft.EntityFrameworkCore.Tools
12
13
14//dodaje se u appsettings.json
15
16  "ConnectionStrings": {
17    "DefaultConnection": "server=147.91.175.176;user=it23g2016;password=ftnftn2016;database=it23g2016"
18  },
19
20
21//kreirati u okviru projekta folder s imenom Data i unutar njega file NazivProjektaContext.cs
22
23using Microsoft.EntityFrameworkCore;
24//namespace ostaviti
25{public class NazivProjektaContext : DbContext {
26    public NazivProjektaContext(DbContextOptions options) : base(options) { }
27
28    protected override void OnModelCreating(ModelBuilder builder) {
29        builder.Entity<Radnik>().Property(p => p.Mbr);
30
31        builder.Entity<Radnik>().ToTable("radnik2");//naziv tabele u bazi
32    }
33
34    public DbSet<Radnik> Radnik { get; set; }
35}
36
37}
38
39
40//modifikovati Startup.cs i dodati liniju za dodavanje konketsa i njegovo spajanje s konekcijom
41        public void ConfigureServices(IServiceCollection services)
42        {
43            services.AddControllers();
44            services.AddDbContext<NazivProjektaContext>(options =>
45                options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
46        }
47
48//kreirati u okviru projekta folder Models i u njemu klasu Radnik.cs
49using System.ComponentModel.DataAnnotations;
50
51public class Radnik
52    {
53        [Key]
54        public decimal Mbr{get;set;}
55        public string Ime{get;set;}
56        public string Prz{get;set;}
57    }
58}
59
60//pokrenuti komandu u terminalu koja ce na osnovu prethodno kreiranog konteksta i modela tabele kreirati kontroler za istu
61dotnet aspnet-codegenerator controller -name RadnikController -async -api -m Radnik -dc NazivProjektaContext -outDir Controllers