I created a databese, for example, an exploler / data connection / add connection server. Microsoft SQL Server Compact 3.5 (.NET Framework) uses the creation and creation of my own MyDatabes.sdf file.
Now on the exploler server, right click on my databese --- and click on a new request
.
Try running this:
Create table [student]
(
[student_id] Bigint NOT NULL,
[bornnumber] Varchar(10) NOT NULL,
[branch] Integer NOT NULL,
[specialization] Integer NOT NULL,
[year] Smallint NULL,
[studygroup] Varchar(5) NOT NULL,
[started] Datetime NULL,
[finished] Datetime NULL,
[status] Char(1) NULL,
Primary Key ([student_id])
)
click execute query:
shows the table Query Definitions. Difference is written
"The SQL CREATE TABLE construct or statement is not supported."
Click to connect
Shows SQL Executation ERROR
"Error source: SQL Server Compact ADO.NET Data PRovider Error message: The specified data type is not valid. [Data type (if known) = Varchar]";
, ... , ADO, NET Varchar. , , ?
Visual Studio 2010 Ultimate.