Archive | Sci-tech

In BLD, we call this a DataContext class. Note: There are many names used for this class. Entity Framework calls it ObjectContext. Some call it Domain.

I know you can do this using COM, but I figured it would be fun to try this using.NET. The great thing about.NET is it’s so well documented. My starting point for this ex...

As a consequence, I don't know the columns it's going to return (it's kind of the whole point of using it). 2. Since the stored proc uses dynamic SQL, it needs to use s...

ODAC offers wide coverage of the Oracle feature set, supports both Client and Direct connection modes and emphasizes optimized data access strategies. DAC offers wide cov...

The Google Chrome web browser has many options to secure your data using SSL settings. The default settings of Google Chrome for SSL security are set to the middle, not t...

This post is about some of the issues that an NHibernate user can expect when working with EF. Many to one associations and introduce a foreign key property Let’s say ...

The process is slightly different for the Code First and Database First approaches. This post discusses both techniques. Code First Using a Guid as the primary key when...

During these years I experienced varieties of projects with various environment and conditions. Every project helped me to learn new things. Everyday had new experience o...

This system covers timetable for a school, high-school or university. It uses a fast and efficient timetabling algorithm. This has the capability show Room Schedule,Sect...

EDIT1: How we can give permission for a mysql user to create database in cPanel hosting provider...? EDIT2: The Privileges list of user does not show 'CREATE DATABASE' P...

I performed the upgrade, in-place, and restarted mysqld. This was fine. However, then I attempted to connect via the command-line, and received the following error: shel...

And good news: it’s embarassingly easy. So start enjoying the latest features today. Understanding the basics Most of the work is done by the pg_upgrade utility which...

The query will get executed a lot, but ussually with a different parameter, depending on what product name the client wants to search for. The query construction the Enti...

Options For performance reasons, it is common to use read-only slave databases with Looker. This frees up the production database to perform its primary function without...

I still remember the moment when I realized how to get rid of negative thoughts… I was twenty-one, I was broke and living in a small one-room apartment in the middle of ...

Here is my code: string mysqldumpPath = "C:\\Program Files (x86)\\MySQL\\MySQL Workbench 5.2 OSS\\mysqldump.exe"; string cmd = String.Format("-h{0} -u{1} -p{2} {3} >...

Entity Framework can be used from an ASP.NET Application, (using Entity Data Source) or in ASP.NET MVC etc. In this article we will be creating this using MVC App and we’...

My first instinct was to create a separate project file, one just for 64-bit builds, that correctly references the 64-bit SQLite DLL. Mark, my smarter half, found a much ...

My app is based on doctrine (1.2) and I was amazed at how many queries were being executed, but I will save that for another article. set global log_output = 'FILE';set ...

This is not a SQL Server problem. Hyper-Threading virtual cores look totally identical to real cores for the operating system - heck, even the bios. You can nail a proces...

Before you make any of thase operations you need to declare entyty StudentDBEntities entities = new StudentDBEntities(); To Insert the record we can write the follow...

Image Tricks is something you have at any settings-tinkering software, JetPhoto Studio is the official Web publisher makes it useful. Integrated scheduler for free app, p...

Finally I found out how to add the toolbox back in. Go to the VIEW menu Click on Toolbox then once again you can enjoy adding buttons and dropdowns to your hearts cont...

For instance; if you have a stored procedure named getOnlineUsers which queries the Users table and returns the online users, you will find yourself realizing that you do...

And in this tutorial I will guide you on how to delete these blank rows in excel. So here we go: Method 1: To Delete Blank Rows in Excel: In this method we will utiliz...

You would surely copy it again if it is a small file but what if the file was huge? Now you can copy files from one location to another with Pause feature that is now ...

Even though object exists in database but Intellisense is not able to recognize it. Refreshing the cache is quite easy but not necessarily strictly required.

My answer was “oh, we can track down our changes by hand on a SQL file” and “I also try to be smart by saying we can get the latest production DB and compare it with t...

I created 2 wrapper scripts for DiffMerge diffmerge-diff.sh and diffmerge-merge.sh See the source code in the gist . I also created two more scripts for WinMerge: ...

MasterCard is a registered trademark of MasterCard International Incorporated. The MasterCard card may be used everywhere Debit MasterCard is accepted. and other countri...

Oracle is in fact an alias corresponding to: "Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess". So the first step you could do is to change that type to the...

The columns.data option has the ability to read information not only from objects, but also from arrays using the same dotted object syntax as for objects. name[, ]). ...

It's best if you avoid using common keywords when searching for Dbforge Studio For Mysql 4.50.285. Words like: crack, serial, keygen, free, version, full, hacked, torrent...