Please enable JavaScript.

Coggle requires JavaScript to display documents.

Developing Microsoft Azure and Web Services - Coggle Diagram

- - - - Querying and Manipulating Data Using Entity Framework Core
        
        ADO.NET Overview
        
        original low-level data access API
        in the .NET Framework
        
        ADO.NET provider has:
        Connection, Command,DataReader
        DataAdapter,DataSet(tabular data from DB)
        adapterX.Fill(dataSetX);
        
        Asynchronous Operations with ADO.NET
        Use async/await
        
        Create Entity Data Model 7
        
        Code-first approach:
        Code => convention => data in DB
        
        public class StudentsContext : DbContext {
        public StudentsContext() : base("StudentsDB") { }
        public DbSet<Student> Students { get; set; }
        //...other tables...}
        
        data annotations: Map code => DB Schema
        [Table("GlobalProducts")]
        public class Product {
        public int Id { get; set; }
        [Column("ProductName")]
        public string Name { get; set; }
        }
        
        Mapping with Fluent API
        
        1 more item...
        
        Manipulating Data
        
        string sql = "select * from Products where ...;
        var products= context.Products.FromSql<Product>(sql);
        
        SQL statement that returns a scalar value:
        context.Database.ExecuteSqlCommand("insert into...")
        
        lazy loading, only the top level of the data is returned
        
        Querying Data
        
        Language Integrated Query (LINQ)
        
        LINQ queries return an object
        implementing the IEnumerable<T>
        
        var courses = from c in context.Courses
        select c;
  - - - micro-services => building applications by separating it into loosely coupled services
  - - - Benefits ?
        
        Fast-ondemand,
        lower cost, Availability,
        Elasticity,elasticity(flexible)
        
        Cloud Computing Strategies
        
        Infrastructure as a Service (IaaS):
        create virtual machines located on a cloud
        
        Platform as a Service (PaaS)
        cloud platform provides OS,storage, databases, ...
        
        Function as a Service (FaaS) = "serverless"
        ready-to-use platform to develop, run, test, and deploy
        
        Software as a Service (SaaS):ready to use on-demand software
        Ex:Outlook.com web email, Office365