private static void Main( string[] args ) { var model = new DynamicModel( args[0] ); bool whatif = Array.IndexOf( args, "-whatif" ) > 0; IEnumerable<dynamic> packages = model.Query( @" SELECT pr.Id, p.[Key], p.Version, p.NormalizedVersion FROM Packages p INNER JOIN PackageRegistrations pr ON pr.[Key] = p.PackageRegistrationKey WHERE p.NormalizedVersion IS NOT NULL AND p.Version != p.NormalizedVersion" ); foreach ( dynamic package in packages ) { string old = String.Format( "{0}.{1}.nupkg", package.Id.ToLower(), package.Version ); string replacement = String.Format( "{0}.{1}.nupkg", package.Id.ToLower(), package.NormalizedVersion ); Console.WriteLine( "Copy: {0} to {1}", old, replacement ); if ( !whatif ) { File.Copy( Path.Combine( args[1], old ), Path.Combine( args[1], replacement ), true ); } } }
protected void InitializeDatabase() { _cachedDefinitions = new Dictionary<string, DynamicModel>(); _tableDefinitions = new Dictionary<String, dynamic>(); var massive = new DynamicModel(_connectionName); var tableDefinitions = massive.Query(SqlTableScript); foreach (dynamic definition in tableDefinitions){ _tableDefinitions[definition.Table.ToUpper()] = definition; } }
public void Should_connect_to_sql_ce_db() { var dbPath = Path.Combine(new DirectoryInfo(Environment.CurrentDirectory).Parent.Parent.Parent.FullName, "TeamReview.Web", "App_Data", "TeamReview.sdf"); var connectionString = string.Format("Data Source={0};Persist Security Info=False;", dbPath); var database = new DynamicModel("DefaultConnection", "UserProfile", "UserId").SetConnectionString(connectionString); var results = database.Query("SELECT UserName FROM UserProfile"); foreach (var result in results) { Console.WriteLine(result.UserName); } }
public RecordHierarchy GetRecordHierarchy(Entity entity) { var index = 0; var hierarchy = GetEntityHierarchy(null, entity, ref index); var sql = GenerateHierarchySql(hierarchy); var model = new DynamicModel(AdminInitialise.ConnectionStringName); var records = model.Query(sql, entity.Key.Value.Raw).ToList(); var recordHierarchy = GetHierarchyRecords(records, hierarchy); return recordHierarchy; }
public static void Export(ExportArguments exportArgs) { var connStrBuilder = new MySqlConnectionStringBuilder { Server = exportArgs.Server, UserID = exportArgs.User, Password = exportArgs.Password, Database = exportArgs.Database }; var model = new DynamicModel(connStrBuilder.ConnectionString, exportArgs.Table); IEnumerable<dynamic> records = exportArgs.UseQuery ? model.Query(exportArgs.Query) : model.All(); string json = JsonConvert.SerializeObject(records); Console.WriteLine(json); }
public RecordHierarchy GetRecordHierarchy(Entity entity) { _log.InfoFormat("Getting record hierarchy for entity record ({0}#{1})", entity.Name, entity.JoinedKeyWithValue); var index = 0; var hierarchy = GetEntityHierarchy(null, entity, ref index); var sql = GenerateHierarchySql(hierarchy); _log.DebugFormat("Sql hierarchy: \r\n {0}", sql); var model = new DynamicModel(Admin.ConnectionStringName); var records = model.Query(sql, entity.Key.Select(x => x.Value.Raw).ToArray()).ToList(); var recordHierarchy = GetHierarchyRecords(records, hierarchy); return recordHierarchy; }
private static void AdHocQuery() { /* initialize dynamic model */ var tbl = new DynamicModel("MyConnection", tableName: "Customers", primaryKeyField: "CustomerID"); /* retrieve all records via ad-hoc query */ var customers = tbl.Query("SELECT * FROM CUSTOMERS"); /* iterate over result set */ foreach (var customer in customers) { Console.WriteLine("{0} {1} {2} {3}", customer.Title, customer.FirstName, customer.LastName, customer.Suffix); } /* pause output */ Console.ReadLine(); }
public RecordHierarchy GetRecordHierarchy( EntityRecord entityRecord, IList<PropertyDeleteOption> deleteOptions = null) { _log.InfoFormat( "Getting record hierarchy for entity record ({0}#{1})", entityRecord.Entity.Name, entityRecord.JoinedKeyWithValue); var hierarchy = GetEntityHierarchy(entityRecord.Entity, deleteOptions); var sql = GenerateHierarchySql(hierarchy); _log.Debug($"Sql hierarchy: \r\n {sql}"); var model = new DynamicModel(_admin.ConnectionStringName); var records = model.Query(sql, entityRecord.Key.Select(x => x.Raw).ToArray()).ToList(); var recordHierarchy = GetHierarchyRecords(records, hierarchy); return recordHierarchy; }
public static IList<SolicitudEntrega> GetSolicitudesEntregadas() { var sucursalId = int.Parse(ConfigurationManager.AppSettings["SucursalId"]); var tbl = new DynamicModel("diarco", tableName: "SolicitudEntrega", primaryKeyField: "id"); var result = tbl.Query(@"SELECT SolicitudEntrega.id as Id, SolicitudEntrega.startsAt as StartsAt, SolicitudEntrega.sucursalId as SucursalId, User.firstName as ProveedorRazonSocial, ordenDeCompraId as OrdenDeCompraId FROM SolicitudEntrega INNER JOIN User On User.id = SolicitudEntrega.userId INNER JOIN SolicitudEntrega_OrdenDeCompra On SolicitudEntrega_OrdenDeCompra.solicitudEntregaId = SolicitudEntrega.id WHERE SolicitudEntrega.status = 5 and SolicitudEntrega.checks is null ORDER BY SolicitudEntrega.startsAt").ToList().Where(s => s.SucursalId == sucursalId || sucursalId == 0).ToList(); return result.GroupBy(s => s.Id) .Select(g => new SolicitudEntrega { Id = g.Key, StartAt = g.First().StartsAt, ProveedorRazonSocial = g.First().ProveedorRazonSocial, OrdenesDeCompra = string.Join(" | ",g.Select(o => o.OrdenDeCompraId).Distinct()) }).ToList(); }