1: //Setup oracle database connection and connection pool 2: public class OracleConnectionManager 3: { 4: private static string _userName; 5: private static string _password; 6: 7: public OracleConnectionManager(string userName, string password) 8: { 9: _userName = userName; 10: _password = password; 11: } 12: 13: private static ISessionFactory _sessionFactory; 14: private static ISessionFactory SessionFactory { get 15: { 16: if(_sessionFactory == null) 17: { 18: var connectionString = DatabaseConnections.GetOracleConnectionsString(_userName,_password); 19: 20: //Nhibernate Oracle database configuration 21: var configuration = new Configuration(); 22: configuration.DataBaseIntegration(db => 23: { 24: db.ConnectionProvider<NHibernate.Connection.DriverConnectionProvider>(); 25: db.Dialect<NHibernate.Dialect.Oracle10gDialect>(); 26: db.Driver<NHibernate.Driver.OracleDataClientDriver>(); 27: db.ConnectionString = connectionString; 28: }); 29: 30:
// Setup default schema 31: configuration.SetProperty(Environment.DefaultSchema, "DB_SCHEMA_NAME");
Tuesday, May 31, 2016
Code Snippet: Set default database schema in Nhibernate SessionFactory
Monday, May 30, 2016
Open Source Cloud GIS System Setup with Amazon EC2 and Geoserver
Follow these steps to set up the open source cloud based GIS mapping system.
1. Create an Amazon Web Services (AWS) account. You can find instructions for this step in the EC2 Getting Started Guide.
3. Create an Amazon EC2 instance. Instructions are also in the EC2 Getting Started Guide. When choosing an AMI make sure you choose a Windows server with IIS (and ASP.NET) already installed.
4. Connect to your Windows EC2 instance and install GeoServer. You can download GeoServer here. There are multiple setups available. Use the Windows installer. The instructions for the install are here.
5. Copy GIS data and configure map layers. The GeoServer user's manual will guide you through the steps of configuring GeoServer.
6. Start GeoServer on the EC2 instance server.
7. Seed the layers in GeoWebCache on the server. Instructions for this are here. Note that jpeg tiles are smaller than png and the default for base layers. Also png are better quality and will always be used for overlays because they can be transparent and overlays need to support transparency. Seed all layers for zoom levels 0 to 10 for EPSG:4326. If it is a base layer, seed it with jpeg files. If it is an overlay layer, seed it with png files.
1. Create an Amazon Web Services (AWS) account. You can find instructions for this step in the EC2 Getting Started Guide.
3. Create an Amazon EC2 instance. Instructions are also in the EC2 Getting Started Guide. When choosing an AMI make sure you choose a Windows server with IIS (and ASP.NET) already installed.
4. Connect to your Windows EC2 instance and install GeoServer. You can download GeoServer here. There are multiple setups available. Use the Windows installer. The instructions for the install are here.
5. Copy GIS data and configure map layers. The GeoServer user's manual will guide you through the steps of configuring GeoServer.
6. Start GeoServer on the EC2 instance server.
7. Seed the layers in GeoWebCache on the server. Instructions for this are here. Note that jpeg tiles are smaller than png and the default for base layers. Also png are better quality and will always be used for overlays because they can be transparent and overlays need to support transparency. Seed all layers for zoom levels 0 to 10 for EPSG:4326. If it is a base layer, seed it with jpeg files. If it is an overlay layer, seed it with png files.
Thursday, May 26, 2016
Setting up automatic product or build version increment using JENKINS for .NET projects
Steps for setting up automatic product or build version increment using JENKINS Continious Integration server and Visual Studio for .NET projects
Part A - Configure Visual Studio Solution
1. Copy the "AssemblyInfo.cs" from your project solutions and rename into "AssemblyInfo.cs.template"
2. Add a file called "AssemblyInfo.cs.template" and replace with these two lines:
Part A - Configure Visual Studio Solution
1. Copy the "AssemblyInfo.cs" from your project solutions and rename into "AssemblyInfo.cs.template"
2. Add a file called "AssemblyInfo.cs.template" and replace with these two lines:
[assembly:
AssemblyVersion("#VERSION_NUMBER#")]
[assembly:
AssemblyFileVersion("#VERSION_NUMBER#")]
3. In project properties, insert this pre-build command:
"$(SolutionDir)builder-scripts\templates\pre-build\Stamper.exe"
"$(ProjectDir)\"
4. Put the "builder-scripts" folder into your solution
folder. Builder scripts source
Code snippet: Unzip the zip file in C# using DotNetZip
DotNetZip is a FAST, FREE class library and toolset for manipulating zip files. Use VB, C# or any .NET language to easily create, extract, or update zip files.
1: public static void DeCompressFile(string zipFilePath, string extractPath)
2: {
3: string zipToUnpack = zipFilePath;
4: string unpackDirectory = extractPath;
5: using (ZipFile zipfiles = ZipFile.Read(zipToUnpack))
6: {
7: // Here, we extract every entry, but we could extract conditionally based on entry name, size, date, checkbox status, etc.
8: foreach (ZipEntry e in zipfiles)
9: {
10: e.Extract(unpackDirectory, ExtractExistingFileAction.OverwriteSilently);
11: }
12: }
13:
14: Console.WriteLine("Status: Done extracting the zipped Archive");
15: }
Code snippet: Read data from Access Database in C#
Read data from Access Database in C#
1: private static void ReadFromAccess(string accessDbPath)
2: {
3: string connection = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= {0}",accessDbPath);
4: using (OleDbConnection con = new OleDbConnection(connection))
5: {
6: try
7: { con.Open();
8: OleDbCommand cmd = new OleDbCommand("SELECT * FROM Table_NAME", con);
9: OleDbDataReader reader = cmd.ExecuteReader();
10:
11: while (reader.Read())
12: {
13: Console.WriteLine(reader.GetString(0));
14: }
15:
16: }catch(Exception ex)
17: {
18: Console.WriteLine(ex.Message);
19: }finally
20: {
21: con.Close();
22: }
23: }
24: }
Subscribe to:
Posts
(
Atom
)