Finding a new job at Massive Impact

31 באוגוסט 2007

As I already posted I left my job two month ago and after a small vacation I started to look for a new place to work at. The place I finally chose at is Massive Impact. Massive Impact is a start-up company that gives a very smart solution for sales over the mobile phones. It's seems to be a great company with very talent people combine with .Net technologies and for desert, they working with Scrum methodology. It's really good place to work at!
9 תגובות

DLINQ – Advanced topics – Debug mode – part 6

24 באוגוסט 2007

DLINQ is a great ORM engine with a lot of advantages. When I learned this tool I asked myself how I can look at the SQL code that it generates. At the beginning I did it by running my project in debug mode with a break point after the query statement. The SQL statement appears when we hover over the result object or by using the watch window. Debugging using the default hover debug tool Debugging using the watch window As you can see it isn't the most comfortable way to look at the generated SQL. So I read Scott...
אין תגובות

How to add multiple tracking accounts to a page in Google analytics

23 באוגוסט 2007

I want to add some tracking tools to my blog, just to know if someone is interesting in my posts. One of the tracking tools I decide to add was Google analytics – a really powerful tool that gives you a visual view on your site visitors, must viewable posts, traffic sources and much more. So I got into its site and registered my blog as one that I want to track for. Like all other tracking tools I just needed to add a piece of script code and everything supposed to work perfect. The script looks like this: <script...
תגיות: ,
20 תגובות

DLINQ – Advanced topics – How it works in ASP.NET application – part 5

17 באוגוסט 2007

There are two approaches to work with the DataContext object. The first approach is to work with a single DataContext object which is responsible for all the quires and the manipulations in our system. In the second approach we work with several DataContext object. Each request refer to a single atomic operation and will work independency to others operation (The DataContext isn't aware to the previous operations at the current entity). The ASP.Net is a good example for the second approach because each request is being handled independently from the previous operation. For example, if we'll create a user...
אין תגובות

DLINQ – Advanced topics – Transaction support – part 4

13 באוגוסט 2007

As I have mention before the DLINQ is a part of the ADO.NET family and this is a major reason for it to support transaction mechanisms. The DLINQ support the ADO.NET Transaction and the transaction scope. Let's see how we can use it at the following scenarios:               ADO.NET Transaction At ADO.NET Transaction we have to handle the entire transaction process. It includes: opening a connection, starting the transaction, commit and rollback when needed, finish the transaction and close the connection. In a case that the connection object has already been initialized in the DataContext class, we should start the transaction by...
אין תגובות

Introducing to DLINQ – How to write data manipulation in DLINQ (Update, insert and delete) – part 3

10 באוגוסט 2007

DLINK gives maximum flexibility in manipulation data with objects. You must retrieve the object before you update or delete it, and you must initialize a new object before inserting it into the db. Let's see some examples:   Insert a new employee: MyDbDataContext db = new MyDbDataContext();   // Init a new employee object using Object Initializer Employee emp = new Employee() { Id = 10, Name = "New Employee", DepartmentCode = 5 }; db.Employees.Add(emp); db.SubmitChanges();   You can see that I must create a new object before I added it to the Employee collection. After I added it, I must call the SubmitChanges method in order to commit...
2 תגובות

Introducing to DLINQ – How to write the queries – part 2

9 באוגוסט 2007

In this post I'll focus on the query options in DLINQ. Let's take two simple scenarios: 1. Retrieve all the employees with the letter "a" in their first name. 2. Retrieve all employees in the "R&D" department   There are three common ways to write these queries in DLINQ:       1. Using SQL syntax: The most simple (or maybe intuitive) way to write a standard query statement is by using the SQL syntax. For example, for the first scenario we should write a code like this: IEnumerable<Employee> list = from x in db.Employees                                 where x.Name.Contains("a")                              select x;   For the second scenario we should write this one: IEnumerable<Employee> list =...
אין תגובות

Introducing to DLINQ – Entities declaration – part 1

2 באוגוסט 2007

One of the major parts in LINQ project is DLINQ – .Net Language Integrated Query for relational Data. DLINQ is a smart data access layer framework (component of the ADO.NET family), with an advanced runtime infrastructure and design time tools for managing data (queries and data manipulations) from a relational db as an object. The usage of this framework is very easy: The basic class in DLINQ is call "Entity class", each class represent a single database table. The properties in this class will represent the table columns. For example: Employees table: Name Type Notes Id int PK Name nchar(20)   DepartmentCode int FK to Department table Departments table: Name Type Notes Id int PK Name nchar(20)    The tables diagram...
אין תגובות