本文整理汇总了C#中SqlCeConnection.ExecuteMapperQuery方法的典型用法代码示例。如果您正苦于以下问题：C# SqlCeConnection.ExecuteMapperQuery方法的具体用法？C# SqlCeConnection.ExecuteMapperQuery怎么用？C# SqlCeConnection.ExecuteMapperQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlCeConnection的用法示例。
在下文中一共展示了SqlCeConnection.ExecuteMapperQuery方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Index
//
// GET: /Dump/
public ActionResult Index()
{
List<TableModel> tables = new List<TableModel>();
var connectionString = ConfigurationManager.ConnectionStrings["FamilyMembers"].ConnectionString;
if(System.IO.File.Exists(HostingEnvironment.MapPath("~/App_Data/FamilyMembersDemo.sdf")))
{
using(var connection = new SqlCeConnection(connectionString))
{
connection.Open();
var schemaTables = connection.ExecuteMapperQuery("select TABLE_NAME from information_schema.tables");
foreach(var schemaTable in schemaTables)
{
if(schemaTable.TABLE_NAME == "EdmMetadata")
{
continue;
}
var table = new TableModel()
{
Name = schemaTable.TABLE_NAME
};
var columns =
connection.ExecuteMapperQuery(
"select * from information_schema.columns where TABLE_NAME = @TableName",
new {TableName = table.Name});
table.Columns = columns.Select(x => new ColumnModel()
{
Name = x.COLUMN_NAME,
Type = x.DATA_TYPE + "(" + x.CHARACTER_MAXIMUM_LENGTH + ")",
Nullable = x.IS_NULLABLE
}).ToArray();
var dataSql = "select * from " + table.Name;
var command = connection.CreateCommand();
command.CommandText = dataSql;
using(var reader = command.ExecuteReader())
{
while(reader.Read())
{
var data = new object[reader.FieldCount];
reader.GetValues(data);
table.Data.Add(data);
}
}
tables.Add(table);
}
}
}
var demoSvc = new DemoSystem();
return View(new DumpModel()
{
Tables = tables,
Demos = demoSvc.ListDemos()
});
}