|
public ForType ( |
||
| type | ||
| return | NPoco.PocoData | |
public void Test11()
{
var fakeReader = new FakeReader();
var pocoDataFactory = new PocoDataFactory(new MapperCollection());
var newPropertyMapper = new PropertyMapper();
var pocoData = pocoDataFactory.ForType(typeof(NestedConvention));
newPropertyMapper.Init(fakeReader, pocoData);
newPropertyMapper.Map(fakeReader, new RowMapperContext() { PocoData = pocoData });
var sw = Stopwatch.StartNew();
for (int j = 0; j < 1000; j++)
{
newPropertyMapper = new PropertyMapper();
newPropertyMapper.Init(fakeReader, pocoData);
for (int i = 0; i < 1000; i++)
{
newPropertyMapper.Map(fakeReader, new RowMapperContext() { PocoData = pocoData });
}
}
sw.Stop();
Console.WriteLine("Elapsed Time (ms): {0}", sw.ElapsedMilliseconds);
//250
}
private Sql GetExistsSql <T>(object primaryKeyorPoco, bool isPoco)
{
var index = 0;
var pd = PocoDataFactory.ForType(typeof(T));
var primaryKeyValuePairs = GetPrimaryKeyValues(this, pd, pd.TableInfo.PrimaryKey, primaryKeyorPoco, isPoco);
var sql = string.Format(DatabaseType.GetExistsSql(), DatabaseType.EscapeTableName(pd.TableInfo.TableName), BuildPrimaryKeySql(this, primaryKeyValuePairs, ref index));
var args = primaryKeyValuePairs.Select(x => x.Value).ToArray();
return(new Sql(sql, args));
}
public Task <int> UpdateAsync <T>(T poco, Expression <Func <T, object> > fields)
{
var expression = DatabaseType.ExpressionVisitor <T>(this, PocoDataFactory.ForType(typeof(T)));
expression = expression.Select(fields);
var columnNames = ((ISqlExpression)expression).SelectMembers.Select(x => x.PocoColumn.ColumnName);
var otherNames = ((ISqlExpression)expression).GeneralMembers.Select(x => x.PocoColumn.ColumnName);
return(UpdateAsync(poco, columnNames.Union(otherNames)));
}
private async Task <int> UpdateBatchAsyncImp <T>(IEnumerable <UpdateBatch <T> > pocos, BatchOptions options, bool sync)
{
options = options ?? new BatchOptions();
int result = 0;
try
{
OpenSharedConnectionInternal();
PocoData pd = null;
foreach (var batchedPocos in pocos.Chunkify(options.BatchSize))
{
var preparedUpdates = batchedPocos.Select(x =>
{
if (pd == null)
{
pd = PocoDataFactory.ForType(x.Poco.GetType());
}
return(UpdateStatements.PrepareUpdate(this, pd, pd.TableInfo.TableName, pd.TableInfo.PrimaryKey, x.Poco, null, x.Snapshot?.UpdatedColumns()));
}).ToArray();
var sql = new Sql();
foreach (var preparedUpdate in preparedUpdates)
{
if (preparedUpdate.Sql != null)
{
sql.Append(preparedUpdate.Sql + options.StatementSeperator, preparedUpdate.Rawvalues.ToArray());
}
}
using (var cmd = CreateCommand(_sharedConnection, sql.SQL, sql.Arguments))
{
result += sync
? ExecuteNonQueryHelper(cmd)
: await ExecuteNonQueryHelperAsync(cmd).ConfigureAwait(false);
}
}
}
catch (Exception x)
{
OnExceptionInternal(x);
throw;
}
finally
{
CloseSharedConnectionInternal();
}
return(result);
}
public async Task <int> InsertBatchAsync <T>(IEnumerable <T> pocos, BatchOptions options = null)
{
options = options ?? new BatchOptions();
var result = 0;
try
{
OpenSharedConnectionInternal();
PocoData pd = null;
foreach (var batchedPocos in pocos.Chunkify(options.BatchSize))
{
var preparedInserts = batchedPocos.Select(x =>
{
if (pd == null)
{
pd = PocoDataFactory.ForType(x.GetType());
}
return(InsertStatements.PrepareInsertSql(this, pd, pd.TableInfo.TableName, pd.TableInfo.PrimaryKey, pd.TableInfo.AutoIncrement, x));
}).ToArray();
var sql = new Sql();
foreach (var preparedInsertSql in preparedInserts)
{
sql.Append(preparedInsertSql.Sql + options.StatementSeperator, preparedInsertSql.Rawvalues.ToArray());
}
using (var cmd = CreateCommand(_sharedConnection, sql.SQL, sql.Arguments))
{
result += await ExecuteNonQueryHelperAsync(cmd);
}
}
}
catch (Exception x)
{
OnExceptionInternal(x);
throw;
}
finally
{
CloseSharedConnectionInternal();
}
return(result);
}
/// <summary>
/// Performs an SQL Insert
/// </summary>
/// <param name="poco">The POCO object that specifies the column values to be inserted</param>
/// <returns>The auto allocated primary key of the new record, or null for non-auto-increment tables</returns>
/// <remarks>The name of the table, it's primary key and whether it's an auto-allocated primary key are retrieved
/// from the POCO's attributes</remarks>
public Task <object> InsertAsync <T>(T poco)
{
var pd = PocoDataFactory.ForType(poco.GetType());
return(InsertAsync(pd.TableInfo.TableName, pd.TableInfo.PrimaryKey, pd.TableInfo.AutoIncrement, poco));
}
public Task <int> DeleteAsync(object poco)
{
var pd = PocoDataFactory.ForType(poco.GetType());
return(DeleteAsync(pd.TableInfo.TableName, pd.TableInfo.PrimaryKey, poco));
}
public Task <int> UpdateAsync(object poco, object primaryKeyValue, IEnumerable <string> columns)
{
var pd = PocoDataFactory.ForType(poco.GetType());
return(UpdateAsync(pd.TableInfo.TableName, pd.TableInfo.PrimaryKey, poco, primaryKeyValue, columns));
}
