RcBuilder@walla.com
call centre: 054-5614020

LINQ 2 SQL

Posted by: RcBuilder  /   Category: ADO.NET / button / Button / DBA / div / GridView / HTML / LINQ 2 SQL / SOURCE CODE / SQL   /   No Comments
09
Nov
2014

LINQ 2 SQL STEPS 1. add new Item -> Linq To SQL Classes (.dbml) 2. open server explorer -> create new connection to the desired dataBase 3. drag-drop the tables you want to map to objects remark: you can also drag stored Procedures, views and more ... 4. add -> associations (create the connections between the tables - foreign keys) 5. use.

Read more

Entity Framework DataBase First

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework / SQL   /   No Comments
31
Oct
2014

Entity Framework DataBase First Create Entity Data Model * Add -> New Item -> (Data Tab) ADO.NET Entity Data Model (.edmx) -> set mame -> ok * in the wizard -> choose 'Generate from database' option * choose the connection string (web.config) or set a new one -> set the connection name -> next * choose the tables, views and.

Read more

Entity Framework Model First

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework / SQL / Stored Procedure   /   No Comments
30
Oct
2014

Entity Framework Model First Create model * Add -> New Item -> (Data Tab) ADO.NET Entity Data Model (.edmx) -> set mame -> ok * in the wizard -> choose 'Empty Model' option * by right clicking within the edmx area we can choose which elements to add to our model - Entity : add a new POCO object (Book,.

Read more

Entity Framework Code First

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework   /   No Comments
30
Oct
2014

Entity Framework Code First Create model * create entities within the code (users, products etc.) * create a new class inherit from DbContext (serve as our database connector) * set the connection string in the app.config   notice! the name MUST be identical to our database connector name! (default mode) * add the created objects from the first chapter as DbSet.

Read more

Entity Framework Migrations

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework / SQL   /   No Comments
30
Oct
2014

Entity Framework Migrations Manual Migrations * usually works alongside the 'Code First' approach * Migrations are updates package for model structure changes (classes), we can see information about all the changes performed in each migration and we can roll back to a specific migration * open the Package Manager (PM) console - Tools -> Library Package Manager -> Package Manager Console * enable.

Read more

Entity Framework BUGS

Posted by: RcBuilder  /   Category: ADO.NET / BUGS / Entity Framework   /   No Comments
30
Oct
2014

Entity Framework BUGS - issue - when using the code first approach we've got the following message "The type xxxxx was not mapped" - fix - change the object hierarchy. don't set the objects to map within another class (they should be directly under a namespace and not cascading under another class) - issue - while generating the edmx file we've got the.

Read more

Entity Framework Advantages & DisAdvantages

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework   /   No Comments
28
Oct
2014

Entity Framework Advantages & DisAdvantages * EF saves a lot of time of the object mapping, the writing of the stored Procedures, views, functions and more ... * EF is more convenient for the developers and easier to work with * EF mapped automatically therefore, any structured radical change can be implemented faster than searching all the Stored.

Read more

Entity Framework – APPROACHES

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework   /   No Comments
28
Oct
2014

Entity Framework - APPROACHES there are 3 approaches to use EF 1.DataBase First mapping an existing data base into code model 2.Code First create a new data base based on created code objects 3.Model First create an empty model we can later on generate a database based on it. in this approach we'll do most of our definitions using the designer instead.

Read more

Entity Framework – GENERAL

Posted by: RcBuilder  /   Category: ADO.NET / Entity Framework   /   No Comments
28
Oct
2014

Entity Framework - GENERAL * EF = Entity Framework * EF is an ORM (Object Relational Mapper) * EDM = Entity Data Model (edmx files) * PM = Package Manager (Console) * we can find 'DbContext' class under System.Data.Entity namespace, this class will function as our database two ways connector * if the EF not installed on the machine, we can.

Read more
  • פיתוח מערכות
  • פתרונות טכנולוגים
  • קידום אתרים
  • בניית אתרים