csharp Archives - 7 중 2 번째 페이지

EF 내에 ForeignKey 구성에 따른 스키마 생성

ICollection 사용

public					ICollection<Student>		m_listLandSiteDataText		{ get; set; }

protected override void Up(MigrationBuilder migrationBuilder)
{
	migrationBuilder.AddColumn<int>(
		name: "CourseId",
		table: "Students",
		nullable: true);

	migrationBuilder.CreateIndex(
		name: "IX_Students_CourseId",
		table: "Students",
		column: "CourseId");

	migrationBuilder.AddForeignKey(
		name: "FK_Students_Courses_CourseId",
		table: "Students",
		column: "CourseId",
		principalTable: "Courses",
		principalColumn: "CourseId",
		onDelete: ReferentialAction.Restrict);
}

public ICollection<Student> m_listLandSiteDataText { get; set; }

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.AddColumn<int>(

table: "Students",

nullable: true);

migrationBuilder.CreateIndex(

table: "Students",

column: "CourseId");

migrationBuilder.AddForeignKey(

table: "Students",

column: "CourseId",

principalTable: "Courses",

principalColumn: "CourseId",

onDelete: ReferentialAction.Restrict);

}

Index와 ForeignKey 없이 생성

[ForeignKey("Course")]
public					int							CourseId					{ get; set; }

[ForeignKey("CourseId")]
public					int							CourseId					{ get; set; }

protected override void Up(MigrationBuilder migrationBuilder)
{
	migrationBuilder.AddColumn<int>(
		name: "CourseId",
		table: "Students",
		nullable: false,
		defaultValue: 0);
}

[ForeignKey("Course")]

public int CourseId { get; set; }

[ForeignKey("CourseId")]

public int CourseId { get; set; }

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.AddColumn<int>(

table: "Students",

nullable: false,

defaultValue: 0);

}

virtual 사용시

public					int							CourseId					{ get; set; }
[ForeignKey("CourseId")]
public	virtual			Course						m_mvLandSiteDataImage		{ get; set; }

protected override void Up(MigrationBuilder migrationBuilder)
{
	migrationBuilder.AddColumn<int>(
		name: "CourseId",
		table: "Students",
		nullable: false,
		defaultValue: 0);

	migrationBuilder.CreateIndex(
		name: "IX_Students_CourseId",
		table: "Students",
		column: "CourseId");

	migrationBuilder.AddForeignKey(
		name: "FK_Students_Courses_CourseId",
		table: "Students",
		column: "CourseId",
		principalTable: "Courses",
		principalColumn: "CourseId",
		onDelete: ReferentialAction.Cascade);
}

public int CourseId { get; set; }

[ForeignKey("CourseId")]

public virtual Course m_mvLandSiteDataImage { get; set; }

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.AddColumn<int>(

table: "Students",

nullable: false,

defaultValue: 0);

migrationBuilder.CreateIndex(

table: "Students",

column: "CourseId");

migrationBuilder.AddForeignKey(

table: "Students",

column: "CourseId",

principalTable: "Courses",

principalColumn: "CourseId",

onDelete: ReferentialAction.Cascade);

}

storedprocedure call

SqlConnection conn = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("sp_getdata", conn);

cmd.Parameters.Add("@userIndex", SqlDbType.Int).Value = MemberNo;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())
{
    Fee = Convert.ToInt32(reader["Fee"].ToString());
}

conn.Close();

SqlConnection conn = new SqlConnection(conStr);

SqlCommand cmd = new SqlCommand("sp_getdata", conn);

cmd.Parameters.Add("@userIndex", SqlDbType.Int).Value = MemberNo;

cmd.CommandType = CommandType.StoredProcedure;

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())

{

Fee = Convert.ToInt32(reader["Fee"].ToString());

}

conn.Close();

asp.net C# textbox 에서 자동완성

@Html.TextBoxFor(
model => model.m_modelAccout.m_strExpenseMoney, new
	{
		@class = "typeahead",
		autocomplete = "off",
		data_provide = "typeahead",
		data_items = "4",
		data_source = Model.a
	}
)

@Html.TextBoxFor(

model => model.m_modelAccout.m_strExpenseMoney, new

{

@class = "typeahead",

autocomplete = "off",

data_provide = "typeahead",

data_items = "4",

data_source = Model.a

}

)

var listevents = new List<string>();
listevents.Add("1111");
listevents.Add("1222");
listevents.Add("1333");
listevents.Add("1234");
listevents.Add("1555");

var events = listevents.ToArray();
var strJson = JsonConvert.SerializeObject(listevents);

var listevents = new List<string>();

listevents.Add("1111");

listevents.Add("1222");

listevents.Add("1333");

listevents.Add("1234");

listevents.Add("1555");

var events = listevents.ToArray();

var strJson = JsonConvert.SerializeObject(listevents);

anydragon

참고자료

최신 글

보관함

EF 내에 ForeignKey 구성에 따른 스키마 생성

storedprocedure call

asp.net C# textbox 에서 자동완성

태그

링크

메타