Space for Emmie Lewis-Briggman to ramble about various technologies and experiences. All opinions are my own. See disclaimer for details.

All posts in .NET Rambles

256px-Sqlite-square-icon.svg

Issue SQLite is a great way to distribute data to applications in order to integrate with different platforms locally.  Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.  I love it!  The problem is I don’t really appreciate the lack of documentation when I encounter an issue. I had my first issue with attempting to open a SQLite database using a UNC file path in .NET.  I kept getting “Unable Read more


Excel2013FileIcon

Background I had a need to read an Excel file in my data access layer for a WCF service.  I wanted to ensure that I can read the data from the Excel file without the need of any Office drivers etc. to be installed on the web server.  New office versions (since 2007) use XML in excel files.  According to MSDN, the new formats improve file and data management, data recovery, and interoperability with line-of-business systems. They extend what is possible with the binary files of earlier versions. Any application that supports XML can access and work with data in the Read more


131004MackieAD

While attempting to create code for is user in role check recursively I noticed that it was super slow and will eventually error out. The error I received is: An error (87) occurred while enumerating the groups. The group’s SID could not be resolved. After digging further I noticed a mention of ForeignSecurityPrincipal reference. The active directory forest/domain I use includes trusts of an outside forest/domain as sub groups. Apparently the System.DirectoryServices.AccountManagement class does not support retrieving foreign security principal objects into GroupPrincipal objects. Microsoft provided the following information about the foreign security principals. This is a class of objects Read more


cloud.download.data-206

I get this question from developers sometimes while working with the web client. I thought I would share a quick tip and trick on how to override the get web request method in the web client. Very, very simple. Now let’s put some basic object oriented concepts to work. 🙂 How to do it? Create a new class and inherit from System.Net.WebClient. By default the timeout for the webclient is 100 seconds. With this change, the Downloader class has the ability to set the timeout using the property or via the constructor. Usage Happy coding! 🙂


github-logo

Good news!  I am finally starting to load some projects to GitHub.  It may not be much but sharing is caring.  I am starting to understand that GitHub is social networking for developers.  I think I will feel a lot more accomplished once I am sharing with the community and contributing to some open source projects.  Hope you join me! https://github.com/emmielewis


jquery-150x150

Background Without using SharePoint designer, there sometimes is a need to modify the style properties of various elements on a SharePoint page. In enterprise environments, SharePoint designer is frequently turned off for valid reasons from users. I was asked last week to stop the text wrap for a SharePoint column in a list. My first thought was to use jQuery. Woohoo! I was able to easily use the jQuery library to modify CSS attributes for anything on the page. Check out how I did this in SharePoint 2010. jQuery Addition In this example, I want to modify the “Title” column Read more


SharePoint_2010_Platform_Services

Background According to Mary Jo Foley, SharePoint — in case you aren’t among its customers or partners who are deploying, maintaining and fixing it — is the server sibling of Office. It is a collection of six different servers bundled into a single back-end that provide content management, enterprise social networking, intranet search, portal creation and management and collaboration. It is a productivity and collaboration software that remains at the core of corporations around the world. As of 2009, Microsoft has been adding 20,000 SharePoint users per day, every day for the last five years, according to Jared Spataro, Director Read more


fear-of-not-being-good-enough

My Poor Me Rant Everyone has a dream job. I graduated undergrad in 2006 with a Computer Engineering degree determined to work for a company that use .NET technologies.  I am not your average programmer.  Adversity is my middle name.  I had my children (5) while in college and working full time.  I don’t have a stick figure and I am African American female in a tech world. 😐  I am 30 years old and I’ve been programming professionally for over 6 years as an enterprise developer. There is still so much I want to learn.  I try to continue Read more


HardWorkAndLazy

Using yield return enables you to avoid fully loading a collection of results. It provides the data one at a time vs. all at once. It is generally helpful when needing to build lists dynamically with LINQ because of the lazy loading capabilities. Using yield return will not generate a result until a call is made for that specific result. We all love the joys of LINQ and lazy is right up my alley. Think of the suffering LINQ would have without being able to evaluate objects in a lazy format. Let’s take a look at an example. I have Read more