Thursday, March 10, 2011

Table types doesn’t support Entity Framework


/// <summary>
Saves bulk employees at once
/// </summary>
/// <param name="dtContainer"></param>
public void SaveEmployees(DataTable dtContainer) //this dtContainer exactly match your table type which is created in sqlserver
using (var context = DataObjectFactory.CreateContext())
SqlParameter param = new SqlParameter("@YourSPParameterNameHere", SqlDbType.Structured);
param.Value = dtContainer;
param.TypeName = "EMPItemsType"; //Name of you tabletype which you have created in sqlserver
EntityConnection entityConnection = (EntityConnection)context.Connection;
SqlConnection sqlConnection = (SqlConnection)entityConnection.StoreConnection; //getting sqlconnection string from EntityConnection
SqlCommand sqlCommand = new SqlCommand("SaveEmployees", sqlConnection); // specify the sp name
sqlCommand.CommandType = CommandType.StoredProcedure;
int result = sqlCommand.ExecuteNonQuery();