1 pièce(s) jointe(s)
CreateTable me dit table non trouvé.
Bonjour ,
ce ligne de code me renvoie une exception (image attaché).
Ligne de code :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
| string sd;
sd = "CREATE TABLE [dbo].[Tokens] (";
sd = sd + "[TokenId] INT IDENTITY(1, 1) NOT NULL,";
sd = sd + "[fromAccountId] INT NOT NULL,";
sd = sd + "[TokenNumber] INT NOT NULL,";
sd = sd + "[From] DATETIME NOT NULL,";
sd = sd + "[Enabled] BIT DEFAULT((0)) NOT NULL,";
sd = sd + "[Expiracy] DATETIME DEFAULT('1900-01-01T00:00:00.000') NOT NULL,";
sd = sd + "[TimeRental] INT DEFAULT((0)) NOT NULL,";
sd = sd + "[SFlags] INT DEFAULT((0)) NOT NULL,";
sd = sd + "[ExpiracyHorsLine] DATETIME DEFAULT('1900-01-01T00:00:00.000') NOT NULL,";
sd = sd + "CONSTRAINT[PK_dbo.Tokens] PRIMARY KEY CLUSTERED([TokenId] ASC)";
sd = sd + ");";
Context.Database.ExecuteSqlCommand(sd); |
Pièce jointe 315530
J'utilise EntityFrameWork parceque uniquement je suis obligé.
C'est bien plus simple de passer par les fichiers.
Donc , pour finir
comment je fais pour créer une table ???????
J'ai essayer ceux-ci :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
Database.SetInitializer(new DropCreateDatabaseAlways<Tcontext>());
Context.Database.CreateIfNotExists();
//Context.Database.CreateIfNotExists();
string sd;
sd = "CREATE TABLE [dbo].[Tokens] (";
sd = sd + "[TokenId] INT IDENTITY(1, 1) NOT NULL,";
sd = sd + "[fromAccountId] INT NOT NULL,";
sd = sd + "[TokenNumber] INT NOT NULL,";
sd = sd + "[From] DATETIME NOT NULL,";
sd = sd + "[Enabled] BIT DEFAULT((0)) NOT NULL,";
sd = sd + "[Expiracy] DATETIME DEFAULT('1900-01-01T00:00:00.000') NOT NULL,";
sd = sd + "[TimeRental] INT DEFAULT((0)) NOT NULL,";
sd = sd + "[SFlags] INT DEFAULT((0)) NOT NULL,";
sd = sd + "[ExpiracyHorsLine] DATETIME DEFAULT('1900-01-01T00:00:00.000') NOT NULL,";
sd = sd + "CONSTRAINT[PK_dbo.Tokens] PRIMARY KEY CLUSTERED([TokenId] ASC)";
sd = sd + ");";
Context.Database.ExecuteSqlCommand(sd); |
Et ca ne marche pas ca renvoie l'exception "dbo.xxx" non trouvé.
